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

Note that you should have been granted the rights to create tables directly, not by a role.

Arjan.

>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);
>end;
Received on Tue Jul 21 1998 - 13:01:30 CDT