We are working with TD6.2 Which is working fine with Oracle 12C, but when we upgrade the Oracle 19C our application started abruptly closing ( Crashing)
When we debug the code the crash is at the Centura API function SqlPLSQLCommand() trying to execute the procedure , in the Event viewer we could see the sqlora32.dll is crashing with Exception code C0000092 ( Unhand-led Exception).
We are trying to execute a stored procedure using for which the input and outputs are
Its only one input it is a number
3 outputs : all three output parameters are dynamic String arrays.
As suggested by the other blogs from the same community we have tried re compiling the procedures and below alter command , but still application is crashing.
alter session set events '10946 trace name context forever, level 65536';
Please help us on how to resolve the issue.
Regards,
Phani
TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C
-
- Site Admin
- Posts: 434
- Joined: 05 Mar 2017, 20:57
- Location: Stroud, England <--> Tauranga, New Zealand
Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C
.
TD6.2 is only certified as far as ORA12c, and is way beyond end-of-life..
Only TD7.3.0 and onwards is certified with ORA19c ( TD7.2 is not ) ....
However, if you want to be clutching at straws, TD6.2 is a 32bit Client, and so must any new Oracle 19 client installation ,
even against a 64bit Server running on a 64bit workstation.
Check you have the ORA19c 32bit Client installed by TNSPing from a cmd prompt. It should output '...for 32bit Windows: Version 19.0.0.0....'
This will confirm you are running the 32bit ORA 19c Client.
Also check that your local TNS_ADMIN environmental path is also pointing to the correct software install . i.e. 32bit , not 64bit.
You must have a TNSNAMES.ora in this path, which is where the 32bit ORA 19c client is installed.
That's all I can think of, except the obvious.... upgrade to a proper compatible version: TD7.3
.
TD6.2 is only certified as far as ORA12c, and is way beyond end-of-life..
Only TD7.3.0 and onwards is certified with ORA19c ( TD7.2 is not ) ....
However, if you want to be clutching at straws, TD6.2 is a 32bit Client, and so must any new Oracle 19 client installation ,
even against a 64bit Server running on a 64bit workstation.
Check you have the ORA19c 32bit Client installed by TNSPing from a cmd prompt. It should output '...for 32bit Windows: Version 19.0.0.0....'
This will confirm you are running the 32bit ORA 19c Client.
Also check that your local TNS_ADMIN environmental path is also pointing to the correct software install . i.e. 32bit , not 64bit.
You must have a TNSNAMES.ora in this path, which is where the 32bit ORA 19c client is installed.
That's all I can think of, except the obvious.... upgrade to a proper compatible version: TD7.3
.
Greetings from New Zealand
Steve Leighton
Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand
www.banksidesystems.co.uk
Steve Leighton
Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand
www.banksidesystems.co.uk
Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C
Thanks for your Suggestion Steve, With TD 6.2 we are able to connect and execute normal queries success fully , the crash occurring only in executing stored with out params having this problem.
Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C
Same issue with TD 7.3 as well.. issue occurs when we pass a
String: strArrayOut[*]
Either in IN or OUT of a oracle procedure.
F.E
Set bOk = SqlPLSQLCommand( hSqlA, 'mypackage.myproc ( strArrayOut)' )
After executing this an error pops "Internal memory has become invalid...." and program crash.
Anyone having any solution?
String: strArrayOut[*]
Either in IN or OUT of a oracle procedure.
F.E
Set bOk = SqlPLSQLCommand( hSqlA, 'mypackage.myproc ( strArrayOut)' )
After executing this an error pops "Internal memory has become invalid...." and program crash.
Anyone having any solution?
Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C
For those who are looking for the solution :-
Goto toad or sqlplus and run the below two commands, then run your application.
alter session set events '10946 trace name context forever, level 65536';
ALTER PACKAGE mypackage COMPILE PACKAGE;
Enjoy !!!
Goto toad or sqlplus and run the below two commands, then run your application.
alter session set events '10946 trace name context forever, level 65536';
ALTER PACKAGE mypackage COMPILE PACKAGE;
Enjoy !!!
Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C
We have had similar problem with Oracle 11 and TD3.1 - best workaround for us was to wrap procedure code with begin-end anonymous block and run with SqlOraPLSQLPrepare and SqlOraPLSQLExecute.
Who is online
Users browsing this forum: [Ccbot] and 0 guests