Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: can't create table in SQL script?

Re: can't create table in SQL script?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 6 Oct 1998 22:13:58 GMT
Message-ID: <361c7945.2795271@netnews.worldnet.att.net>


Are you trying to execute the CREATE TABLE statement within some PL/SQL code? It would help me (to figure this out), if you would post the script, or at least post the part that is giving you problems.

regards,

Jonathan Gennick

On Mon, 05 Oct 1998 17:56:09 GMT,
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 - 17:13:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US