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

2003-09-06 01:05:20 AM
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.
-