Re: can't create table in SQL script?

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>
>

I did not think that you could use DDL statements within PL/SQL. CREATE is such a statement.

Yours,  

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Mon Oct 05 1998 - 00:00:00 CDT