-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|