Re: Create Table in PL/SQL

>ORA-06550: line 3, column 1:
>PLS-00103: Encountered the symbol "CREATE" when expecting one of the
>following:
>
> begin declare exit for goto if loop mod null pragma raise
> return select update while <an identifier>
> <a double-quoted delimited-identifier> <a bind variable> <<
> close current delete fetch lock insert open rollback
> savepoint set sql commit <a single-quoted SQL string>

You should use dynamic SQL (DBMS_SQL package)

Karlis Ogsts
Konts Ltd.
ogsts_at_cclu.lv
http://www.konts.lv Received on Sat Dec 20 1997 - 00:00:00 CST