Forum Stats

  • 3,782,436 Users
  • 2,254,645 Discussions
  • 7,880,078 Comments

Discussions

PLS-00103 Error

660136
660136 Member Posts: 27
edited Sep 28, 2008 8:12AM in SQL & PL/SQL
Hi,

I am writing a typical PL/SQL statement and I am encountering the following error:

ORA-06550: line 7, column 16:
PLS-00103: Encountered the symbol "IN" when expecting one of the following...

The problem is that there is no IN symbol on this line so I'm quite confused.
3. declare
4.      cursor cust is
5.                      select order_id, item_id, customer_id from ph2_item 
6.                      order by customer_id
7.                      for update of order_id;
8.                      
9.      neworder in ph2_item.order_id%type;
As you can see the nearest IN statement appears on the 9 ^th^ line.
Tagged:

Answers

This discussion has been closed.