Re: dynamic DML statements in stored procedures

...

> >-- create or replace procedure ptest
> >-- as
> >declare
> > TblStatement varchar2(32000);
> > c integer ;
> >begin
> > TblStatement := 'CREATE TABLE TTEST (CTEST VARCHAR2(30))' ;
> > c := dbms_sql.open_cursor;
> > dbms_sql.parse(c, TblStatement, dbms_sql.v7) ;
> > dbms_sql.close_cursor(c);
> >end ;
> >/
> >
> >and I run it as an anoymous PL/SQL block, it works !
> >
> >SQL> start ptest
> >
> >PL/SQL procedure successfully completed.
> >
> >SQL> desc ttest
> > Name Null? Type
> > ------------------------------- -------- ----
> > CTEST VARCHAR2(30)
> >

How is this possible as you never call dbms_sql.execute?

Paul Received on Fri Jul 03 1998 - 13:22:06 CDT