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

From: Rahul Sachan <sachan5k_at_yahoo.com>
Date: 5 Sep 2003 10:05:20 -0700
Message-ID: <43512889.0309050905.27eee98c_at_posting.google.com>


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. Received on Fri Sep 05 2003 - 19:05:20 CEST

Original text of this message