TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C

Discussion forum about all things Team Developer 5.x and 6.x
onlyphanim@gmail.com
India
Posts: 2
Joined: 13 Oct 2021, 10:57
Location: India

TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C

Post by onlyphanim@gmail.com » 21 Oct 2021, 05:16

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

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 338
Joined: 05 Mar 2017, 20:57
Location: Stroud, England <--> Tauranga, New Zealand

Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C

Post by Steve Leighton » 22 Oct 2021, 22:05

.
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

Image

onlyphanim@gmail.com
India
Posts: 2
Joined: 13 Oct 2021, 10:57
Location: India

Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C

Post by onlyphanim@gmail.com » 28 Oct 2021, 09:23

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.

fcall
India
Posts: 2
Joined: 29 Jun 2022, 16:53
Location: Chennai, India

Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C

Post by fcall » 30 Jun 2022, 20:12

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?

fcall
India
Posts: 2
Joined: 29 Jun 2022, 16:53
Location: Chennai, India

Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C

Post by fcall » 30 Jun 2022, 20:57

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 !!!

nortonex
Poland
Posts: 13
Joined: 04 Apr 2018, 07:54
Location: Poland

Re: TeamDeveloper API SqlPLSQLCommand crashing with Oracle 19C

Post by nortonex » 01 Jul 2022, 07:44

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.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest