Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is this possible

Re: Is this possible

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 15 Jul 2006 15:24:16 -0700
Message-ID: <1153002275.435827@bubbleator.drizzle.com>


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.org
Received on Sat Jul 15 2006 - 17:24:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US