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

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
8,127 Expert 4TB
what makes you create and close so many connections.
Sep 13 '08 #2
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
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.