Re: executing procedure from another procedure
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 17 Dec 2005 11:09:27 +0100
Message-ID: <sto7q1tuvoqnttrnmld5rm6pntr4qemu51_at_4ax.com>
Date: Sat, 17 Dec 2005 11:09:27 +0100
Message-ID: <sto7q1tuvoqnttrnmld5rm6pntr4qemu51_at_4ax.com>
On 17 Dec 2005 02:02:43 -0800, "Muthu Kumar G" <g.muthukumar_at_gmail.com> wrote:
>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;
Which should be qualified as non-scalable code.
You are on the way to hell.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Dec 17 2005 - 11:09:27 CET