| loop error [message #266313] |
Mon, 10 September 2007 08:48  |
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 #266316 is a reply to message #266313] |
Mon, 10 September 2007 08:53  |
ThomasG
Messages: 3212
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 |
 |
Littlefoot
Messages: 21825
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.
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
