Re: Dynamically execute PL/SQL statement

DECLARE v NUMBER;

BEGIN EXECUTE IMMEDIATE
   'BEGIN :1:=10;END;'
   USING OUT v;

DBMS_OUTPUT.PUT_LINE(v);

END; Jan Received on Sat Oct 30 2004 - 11:39:49 CDT