Re: Dynamically execute PL/SQL statement
From: Jan <janik_at_pobox.sk>
Date: 30 Oct 2004 09:39:49 -0700
Message-ID: <81511301.0410300839.1c8ae6a8_at_posting.google.com>
Date: 30 Oct 2004 09:39:49 -0700
Message-ID: <81511301.0410300839.1c8ae6a8_at_posting.google.com>
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 - 18:39:49 CEST