471,306 Members | 936 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

ORA-00604 when connect to database

5
I'm writing PRO C program with oracle 8i. My process first connect to the database with using ora_connect(), proceed the task then diconnect with using ora_disconnect(). This would always in a loop, recently after few cycle of connect and disconnect, when the next issue connect statement, it was unable to connect and return me ora-00604 and the process end. Even i restart the process, after few cycle also the same return me ora-00604 during the connect.
Is there anyone have an idea how to resolve this?
Sep 10 '08 #1
3 4974
debasisdas
8,127 Expert 4TB
what makes you create and close so many connections.
Sep 13 '08 #2
lsy
5
my program are in a loop...if it encounter error, it might not disconnect and keep looping in the program, so decided after complete 1 cycle disconnect it.
Sep 16 '08 #3
amitpatel66
2,367 Expert 2GB
Can you try the CONNECT and DISCONNECT statements out side the loop. That should work becuase having CONNECT string inside loop is not advisable
Sep 16 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Adam Ruth | last post: by
1 post views Thread by Doron | last post: by
6 posts views Thread by bdj | last post: by
3 posts views Thread by Michael John | last post: by
1 post views Thread by dabikerdevil | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.