ORA-00604 when connect to database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lsy
    New Member
    • Aug 2005
    • 5

    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?
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    what makes you create and close so many connections.

    Comment

    • lsy
      New Member
      • Aug 2005
      • 5

      #3
      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.

      Comment

      • amitpatel66
        Recognized Expert Top Contributor
        • Mar 2007
        • 2358

        #4
        Can you try the CONNECT and DISCONNECT statements out side the loop. That should work becuase having CONNECT string inside loop is not advisable

        Comment

        Working...