Home » SQL & PL/SQL » SQL & PL/SQL » Error PLS-00103 (oracle91)
Error PLS-00103 [message #422690] Fri, 18 September 2009 06:43 Go to next message
Messages: 56
Registered: May 2009
Location: Hyderabad

Hello all ,
Kindly help in getting out of this error

SQL> ed
Wrote file afiedt.buf

1 create or replace procedure example_cur
2 (x IN varchar2,
3 y OUT ra_customers.customer_name%type)
4 is
5 cursor c1 is select customer_name from ra_customers where customer_id=x;
6 begin
7 open c1;
8 loop
9 fetch c1 in y;
10 exit when c1%notfound;
11 dbms_output.put_line('The Customer Name for customer id '||x||'is ---->'||y);
12 end loop;
13 close c1;
14* end;
SQL> /

Warning: Procedure created with compilation errors.

SQL> sho err

-------- -----------------------------------------------------------------
9/10 PLS-00103: Encountered the symbol "IN" when expecting one of the
. into bulk
The symbol "into was inserted before "IN" to continue.


Re: Error PLS-00103 [message #422691 is a reply to message #422690] Fri, 18 September 2009 06:46 Go to previous messageGo to next message
Messages: 2844
Registered: May 2007
Location: Scotland
Senior Member
Lookup the syntax for the fetch statement
Re: Error PLS-00103 [message #422694 is a reply to message #422690] Fri, 18 September 2009 06:52 Go to previous message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous post (and other ones):

Michel Cadot wrote on Mon, 14 September 2009 08:48
Please use SQL*Plus and copy and paste your session.
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.


[Updated on: Fri, 18 September 2009 06:53]

Report message to a moderator

Previous Topic: How to convert MM/DD/YYYY time format to YYYY-MM-DDTHH:mm:ss.000Z (merged 3)
Next Topic: BLOB records deletion
Goto Forum:

Current Time: Sat Jul 22 14:10:56 CDT 2017

Total time taken to generate the page: 0.05718 seconds