Re: user interaction with procedure

On 10 May, 13:50, 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

Apart from what David has told you, you might consider trying the following query:

select keyword
from v$reserved_words
where keyword like 'ID%';

HTH -g Received on Thu May 10 2007 - 09:09:51 CDT