getting ORA-06511: PL/SQL: cursor already open
Hi , I am executing a Procedure , which is compiling fine , but when executing getting mentioned error Report
Error report -
ORA-06511: PL/SQL: cursor already open
ORA-06512: at "APPS.XX_PUSH_DATA_PR", line 4
ORA-06512: at "APPS.XX_PUSH_DATA_PR", line 19
ORA-06512: at line 2
06511. 00000 - "PL/SQL: cursor already open"
*Cause: An attempt was made to open a cursor that was already open.
*Action: Close cursor first before reopening.
===========below is the procedure ========================
create or replace procedure xx_push_data_pr
as
cursor c is SELECT task_number ,
source_object_name ,
location_id ,
PArty_number,
incident_customer_name,
created_by,