SQLConnect ORA-03113 end-of-file on channel

General discussion forum about all things Team Developer 6.x
e.russo
Italy
Posts: 15
Joined: 16 Feb 2018, 14:02
Location: Turin, Italy

SQLConnect ORA-03113 end-of-file on channel

Post by e.russo » 29 Mar 2018, 08:58

Hi,

in my application I use the SQLConnect function to connect a ORACLE database.
Sometimes in SQLPrepare I have a SQL error (32767 ORA-03313 or ORA-24324).
In this case I try to re-connect to DB with SQLConnect in a loop waiting the network restart, but SQLConnect returns Always TRUE.


Any idea?

Thanks in advance

Enrico

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 400
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: SQLConnect ORA-03113 end-of-file on channel

Post by Dave Rabelink » 03 Apr 2018, 07:33

This sounds familiar to me, but in another case.
It seems that when using Oracle (maybe other DB brands also?) the connections are cached in some way.

So it might that subsequent connects are first internally fetched from a cached resource which will then be reused without actually performing the connect.
In your case, the previous connection is reused without doing a real connect which will return you TRUE on the connect.
(but this is just a hunch).

See the other case, where connect returns TRUE even when it should not:

viewtopic.php?f=30&t=45866
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Return to “General Discussion”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests