Field Service - EBS (MOSC)

MOSC Banner

getting ORA-06511: PL/SQL: cursor already open

edited Sep 15, 2015 10:00AM in Field Service - EBS (MOSC) 2 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center