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

[Rahul Sachan]

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.