executing procedure from another procedure

From: Muthu Kumar G <g.muthukumar_at_gmail.com>
Date: 16 Dec 2005 23:14:51 -0800
Message-ID: <1134803691.330379.230300_at_g14g2000cwa.googlegroups.com>

hello,
i would like to execute a procedure from another procedure. the name of the second procedure needs to be form in run time.

proc-1)
CREATE OR REPLACE PROCEDURE ABC
AS
BEGIN
DBMS_OUTPUT.PUT_LINE('INSIDE ABC');
END;
/

proc-2)
[Quoted] CREATE OR REPLACE PROCEDURE ABC1 (AA IN VARCHAR2, BB IN VARCHAR2, CC IN VARCHAR2)
AS
STR VARCHAR2(10);
nnn number;
BEGIN
STR:=AA||BB||CC;
DBMS_OUTPUT.PUT_LINE(STR); ===>> ABC, -- === HERE I NEED TO CALL THE PROC1 ABC DBMS_OUTPUT.PUT_LINE('HELLO '||nnn);
END;
/

CAN ANY ONE THROW SOME LIGHT ON THIS... REGARDS,
MUTHU KUMAR. Received on Sat Dec 17 2005 - 08:14:51 CET