0

I am getting

java.sql.SQLException: ORA-01000: maximum open cursors exceeded"

error. I want to know the no of open cursors in my Db. I don't have DBA access. I have written the following procedure to delete the thousands/lac of record from DB: 

"create or replace //creating procedure
PROCEDURE SUBSREMOVAL AS 
BEGIN
  DBMS_OUTPUT.PUT_LINE('----DELETING ROW FROM table1 TABLE START------' );
  DELETE from  table1 c where c.X in (select t.Y from table2 t);//delete query
    DBMS_OUTPUT.PUT_LINE('----DELETING ROW FROM table1 TABLE END------' );
  COMMIT;
END SUBSREMOVAL"  //ending procedure
Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
Adarsh Jain
  • 31
  • 1
  • 4
  • 3
    "*maximum open cursors exceeded"* typically means you are not closing your `Statement` or `PreparedStatement` instances properly. You need to show us the Java code that generates the problem. **[edit]** your question do **not** post code or additional information as comments –  Mar 11 '17 at 13:25
  • *Again*: do **not** post code in comments. [edit] your question. –  Mar 11 '17 at 13:54

0 Answers0