Re: PL/SQL package to create tables and/or triggers

Try this:

cursorid integer;
begin

    cursorid:=dbms_sql.open_cursor;

    dbms_sql.parse(cursorid, 'create table...', dbms_sql.v7);
    dbms_sql.execute(cursorid);
    dbms_sql.close_cursor(cursorid);

Good luck
- Ivan Bajon

James wrote in message <35b41022.0_at_news.hawaii.rr.com>...
>Is there a PL/SQL package that will allow me to do this...i dont think
>dbms_sql or dbms_ddl
>will work.
>
>the ideal package
>
>Pac.Proc('create table test (x number)');
>
>thank you in advance,
>
>jf
>
>
Received on Tue Jul 21 1998 - 06:51:39 CDT