Is this possible

create or replace procedure t1 is
strSQL varchar2(50);
my_cursor INTEGER;
begin

        strSQL:='create or replace procedure t2 is';
        strSQL:= strSQL ||' begin';
        strSQL:= strSQL ||'  end t2';

my_cursor:= DBMS_SQL.OPEN_CURSOR;

DBMS_SQL.PARSE(my_cursor, strSQL, DBMS_SQL.V7);

DBMS_SQL.CLOSE_CURSOR(my_cursor);            

end t1; Received on Sat Jul 15 2006 - 17:08:08 CDT