ORA-01000 error even if all statements and resultsets are closed in finally
I am getting ORA-01000 error even if I have closed all statements and
resultsets in finally for all query (not using prepared statements).
Also OPEN_CURSOR is set to 500.
We are using Oracle 8.1.7 and in JDBC driver 'Enable Resultset' is ON
and 'Enable Closing cursors' is OFF
Please suggest how to solve is issue. It's very urget.
Software/Hardware used:
Software/Hardware used:
ASKED:
December 28, 2005 11:22 PM
UPDATED:
December 29, 2005 7:58 AM
RELATED QUESTIONS
- re-writting a cfprocresult froma stored procedure as a regular query type thing
- What does this mean when SQLCOD = -206? I need to write 2 sets embedded SQL statement in my program.
- lora-01017:invalid username/password
- cursors left open in embedded SQL
- ntvdm encountered a hard error windows server 2003
Answer Wiki:
We are using Oracle 8.1.7 and in JDBC driver 'Enable Resultset' is ON
and 'Enable Closing cursors' is OFF
maybe you should first try 'Enable Closing cursors' ON
Are you using bind variables?
that would help a lot
Also is the latest 8.1.7 patch installed, I remember having this problem a long time ago and it was fixed by both a patch and a little change of code using bind variables and avoiding opening cursor in the loop of another cursor .... garbage collection can take some time to destroy the cursors or recordsets in the inner loop
hope that helps a bit
have a good day and a happy new year
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
