Hi,

In one of my PL/SQL Blocks I have a cursor declaration as follows:

CURSOR CUR_MS_SITE IS
SELECT *
FROM CSS_DBA.CSS_MS_SITE
WHERE MS_SITE_ID = v_MS_SITE_ID
FOR UPDATE;

Where MS_SITE_ID is the PK on this table and v_MS_SITE_ID is a predefined variable.

When I tried to execute this, I am getting an error :

ERROR at line 135:
ORA-06550: line 135, column 24:
PLS-00225: subprogram or cursor 'CUR_MS_SITE' reference is out of scope

Any ideas to resolve this pl..

MS Reddy