How fix ORA-01000: maximum open cursors exceeded with out closing Statement.
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.
- 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