Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> user interaction with procedure
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
![]() |
![]() |