DA Morgan schreef:
> krishnamurthy.iyer_at_gmail.com wrote:
>> 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;
>
> Possible yes. Smart? No!
>
> While you are at it take a look at the DBMS_DDL package too if
> you Oracle version isn't really 7. BTW: If it isn't 7 what are
> you doing with that parameter?
Apart from that - it will not work; minimum requirement is to have
a statement between begin and end; - a "NULL;" statement
is sufficient.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Sun Jul 16 2006 - 03:38:06 CDT
