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: 2818
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: 63911
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: Fri Oct 21 19:18:15 CDT 2016

Total time taken to generate the page: 0.09227 seconds