Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Re: PLS-00357 Table,View Or Sequence reference 'string' not allowed in this con

1022721Jul 4 2013 — edited Jul 4 2013

i have the same problem , can somebod help

i pasting my code here , please help me resolving

SQL> declare

  2  continue char(1):='y';

  3   begin

  4  while(continue='y')

  5  loop

  6  dbms_output.put_line('somen');

  7  dbms_output.put_line('do u wan continue');

  8  continue:=to_char(&continue);

  9  end loop;

10  end;

11  /

Enter value for continue: y

old   8: continue:=to_char(&continue);

new   8: continue:=to_char(y);

continue:=to_char(y);

                  *

ERROR at line 8:

ORA-06550: line 8, column 19:

PLS-00357: Table,View Or Sequence reference 'Y' not allowed in this context

ORA-06550: line 8, column 1:

PL/SQL: Statement ignored

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2013
Added on Jul 4 2013
6 comments
4,412 views