Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is this possible
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?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Jul 15 2006 - 17:24:16 CDT