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 - 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?


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
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.