Re: can't create table in SQL script?

You need to use dynamic SQL.

Look in file $ORACLE_HOME/rdbms/admin/dbmssql.sql

Regards

Karsten Weikop
Make IT
Denmark

Email: karsten_at_weikop.dk

badstreetboy_at_my-dejanews.com wrote:
>
> I have a simple create table statement in SQL script. When I complie it in
> SQLPLUS, there is an error:
>
> 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>
>
> Why this happen?
> Thanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Oct 06 1998 - 00:00:00 CDT