By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,291 Members | 3,096 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,291 IT Pros & Developers. It's quick & easy.

How fix ORA-01000: maximum open cursors exceeded with out closing Statement.

P: n/a
Dear All,

We are using Oracle 9i databse and Oracle JDBC Driver version -
9.0.2.0.0(oracle.jdbc.driver.OracleDriver) with JDBC 2.0.

1) The following block of statement returns 0 when executed. Is there
a way to determine whether the session has actually been altered?

st.executeUpdate("ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD
HH24:MI:SS'");
st.executeUpdate("ALTER SESSION SET SESSION_CACHED_CURSORS = 500");

2) Is it possible to have two different columns one having long raw
data type and the other long data type in the same table?
3) We are not able to read a Blob data type having more than 4000
bytes using getBinaryStream() of Oracle.sql.Blob . Is there any other
method to do so?.
4) We are Facing error ORA-01000: maximum open cursors exceeded.Is
there any stored Procedure or any other way besides closing each
statement.
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.