Re: user interaction with procedure

On May 10, 7:50 am, Andrea <netsecur..._at_tiscali.it> wrote:
> 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

You cannot use 'accept' in a PL/SQL block; it is a SQL*Plus command. AFAIK you cannot have an interactive PL/SQL block. What, exactly, are you trying to accomplish? There is likely a much better way to do whatever it is you're trying to do.

David Fitzjarrell Received on Thu May 10 2007 - 07:56:06 CDT