SqlPLSQLCommand crash with Oracle Package

[MWegner]

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

[bheilscher]

Hi,

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

Best regards
Bernd

[MWegner]

Hey Bernd,

it's working. Thank you.

Have a nice weekend. Best regards
Martin