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
aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad
Member

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
Errors for PROCEDURE EXAMPLE_CUR:

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

SQL>

Thanks
M.A.Aiyaz
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
pablolee
Messages: 2813
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: 63806
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.

Regards
Michel

[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: Tue Sep 27 05:56:59 CDT 2016

Total time taken to generate the page: 0.07450 seconds