Re: executing procedure from another procedure
From: Muthu Kumar G <g.muthukumar_at_gmail.com>
Date: 17 Dec 2005 02:02:43 -0800
Message-ID: <1134813763.151218.302620_at_f14g2000cwb.googlegroups.com>
Date: 17 Dec 2005 02:02:43 -0800
Message-ID: <1134813763.151218.302620_at_f14g2000cwb.googlegroups.com>
CREATE OR REPLACE PROCEDURE ABC1 (AA IN VARCHAR2, BB IN VARCHAR2, CC IN
VARCHAR2)
AS
STR VARCHAR2(10);
BEGIN
STR:=AA||BB||CC;
DBMS_OUTPUT.PUT_LINE(STR);
EXECUTE IMMEDIATE 'BEGIN ' || STR || ' END;';
END;
Received on Sat Dec 17 2005 - 11:02:43 CET