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
  • 90,369
  • 161
  • 124
  • 175
Adarsh Jain
  • 31
  • 1
  • 3
  • 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 – a_horse_with_no_name Mar 11 '17 at 13:25
  • *Again*: do **not** post code in comments. [edit] your question. – a_horse_with_no_name Mar 11 '17 at 13:54

0 Answers0