SqlPLSQLCommand crash with Oracle Package

General discussion forum about all databases other than SqlBase.
MWegner
Germany
Posts: 83
Joined: 11 Apr 2017, 07:39
Location: Germany

SqlPLSQLCommand crash with Oracle Package

Post by MWegner » 11 Jun 2015, 15:13

Hey folks,

I think I'm missing something completely or something is wrong with Team Developer. The following lines kill Team Developer without any message.

Code: Select all

Set SqlDatabase = 'XXX'
Set SqlUser  = 'XXX'
Set SqlPassword  = 'XXX'
If SqlConnect ( Sql_Handle )
  Call SqlPLSQLCommand( Sql_Handle, "DBMS_STATS.GATHER_TABLE_STATS('ownname', 'tabname)" )
If Sql_Handle != hWndNULL
  Call SqlDisconnect( Sql_Handle )
TD Version: 6.2.3.44526 UPD1 Build 44526
Windows: Windows 7 Enterprise SP1
Oracle: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod

Best regards
Martin
You do not have the required permissions to view the files attached to this post.

bheilscher
Germany
Posts: 56
Joined: 22 May 2018, 08:59
Location: Braunichswalde

Re: SqlPLSQLCommand crash with Oracle Package

Post by bheilscher » 12 Jun 2015, 10:53

Hi,

I think, SqlPLSQLCommand will not run with default parameters.
The combination of SqlOraPLSQLPrepare and SqlOraPLSQLExecute should work.

Best regards
Bernd
You do not have the required permissions to view the files attached to this post.

MWegner
Germany
Posts: 83
Joined: 11 Apr 2017, 07:39
Location: Germany

Re: SqlPLSQLCommand crash with Oracle Package

Post by MWegner » 12 Jun 2015, 13:31

Hey Bernd,

it's working. Thank you. :)

Have a nice weekend. Best regards
Martin

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests