Home » SQL & PL/SQL » SQL & PL/SQL » loop error
loop error [message #266313] Mon, 10 September 2007 08:48 Go to next message
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Dear guys,

I have compiled the following pl/sql it shows the following error,please help me to compile the procedure.

procedure proc_test
(SBcursor in out pack.Utility.TYpe cursor,
nsno IN number)
for sb_cursor in SBCursor loop
select SB.*,rownum from
(SELECT col1,colu2 from table ) SB;
end loop;

Error:PLS-00221 'string' is not a procedure or is undefined.

-Thanx in advance.

[EDITED by LF - removed bunch of empty lines]

[Updated on: Mon, 10 September 2007 12:12] by Moderator

Report message to a moderator

Re: loop error [message #266315 is a reply to message #266313] Mon, 10 September 2007 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As a senior member you should know the Guide by heart.
So follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).


Re: loop error [message #266316 is a reply to message #266313] Mon, 10 September 2007 08:53 Go to previous messageGo to next message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Sorry, this is

1. not a valid syntax to create a procedure, so it won't compile
2. it doesn't make any sense I can find.

Re: loop error [message #266373 is a reply to message #266316] Mon, 10 September 2007 12:11 Go to previous message
Messages: 21128
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just in case you didn't see this:
PLS-00221: 'string' is not a procedure or is undefined

Cause: An identifier being referenced as a procedure was not declared or actually represents another object (for example, it might have been declared as a function).

Action: Check the spelling and declaration of the identifier. Also confirm that the declaration is placed correctly in the block structure.
Previous Topic: Logon trigger on schema
Next Topic: problem with set define off
Goto Forum:

Current Time: Mon Jul 24 05:57:42 CDT 2017

Total time taken to generate the page: 0.11829 seconds