Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> user interaction with procedure

user interaction with procedure

From: Andrea <netsecurity_at_tiscali.it>
Date: 10 May 2007 05:50:24 -0700
Message-ID: <1178801424.267127.249380@y5g2000hsa.googlegroups.com>


hi,
i would like to run this simple procedure:

create or replace procedure p_test as
BEGIN
 FINE := 'NO';
 EXIT WHEN FINE = 'YES';
  accept ID char prompt "INSERT DOT FOR CONTINUE"    select * from prova;
 IF ID := '.' THEN
   FINE := 'YES';
 END IF;
 END LOOP;
END;
/

but it sho me error:

6/8 PLS-00103: Encountered the symbol "ID" when expecting one of the following:

   := . ( @ % ;

can someone help me please?

thanks Received on Thu May 10 2007 - 07:50:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US