ORA-01001: invalid cursor + ORA-01403: no data found
Hi, I consult for a mistake in the execution of a procedure / package:
HISR_RETEN.p_hisr_retention_all BEGIN, END;
Error when executing the same is:
ORA-01001: invalid cursor
ORA-06512: at "XAJTDB.HISR_RETEN", line 155
ORA-01403: no data found
ORA-06512: at line 1
Schema: xajtdb
Package: HISR_RETEN
Procedure: p_hisr_retention_all
cursor: hisr_freq_cur
I do not have much experience in PL-SQL, but the error tells of a cursor that is not data, and points to the line of the exception.
They may help me solve this?, The most curious is that the problem is not production.
HISR_RETEN.p_hisr_retention_all BEGIN, END;
Error when executing the same is:
ORA-01001: invalid cursor
ORA-06512: at "XAJTDB.HISR_RETEN", line 155
ORA-01403: no data found
ORA-06512: at line 1
Schema: xajtdb
Package: HISR_RETEN
Procedure: p_hisr_retention_all
cursor: hisr_freq_cur
I do not have much experience in PL-SQL, but the error tells of a cursor that is not data, and points to the line of the exception.
They may help me solve this?, The most curious is that the problem is not production.
0