Re: user interaction with procedure

On Thu, 10 May 2007 05:50:24 -0700, Andrea 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?
>

Yes. Manuals.

-- 
http://www.mladen-gogala.com