471,052 Members | 1,360 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

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

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
0 10160

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Adam Ruth | last post: by
6 posts views Thread by bdj | last post: by
reply views Thread by leo001 | 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.