Home » SQL & PL/SQL » SQL & PL/SQL » loop error
loop error [message #266313] Mon, 10 September 2007 08:48 Go to next message
vasudevan
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:
procedure proc_test
(SBcursor in out pack.Utility.TYpe cursor,
nsno IN number)
Is
begin
for sb_cursor in SBCursor loop
select SB.*,rownum from
(SELECT col1,colu2 from table ) SB;
end loop;
end;


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: 64117
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).

Regards
Michel

Re: loop error [message #266316 is a reply to message #266313] Mon, 10 September 2007 08:53 Go to previous messageGo to next message
ThomasG
Messages: 3189
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
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just in case you didn't see this:
Oracle
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: Tue Dec 06 02:55:02 CST 2016

Total time taken to generate the page: 0.08279 seconds