Re: Propblem with executing Oracle SQL scrip

Not sure quite what you mean by "load", but It sounds like you are trying to run multiple sql commands in your sql whindow, however, it only accepts single commands.

You need to run it as a file, so try

    @c:\somepath\myfile.sql

Type this in your sql window (I assume you're on Windows).

"Marek" <marekm@_NO_SPAM_frogware.com> wrote in message news:kFlB6.187443$Z2.2265369_at_nnrp1.uunet.ca...
> this is the script teks I try to execute :
>
> --------------------------------
> drop table part ;
>
> CREATE TABLE part(
> part_id NUMBER,
> part_name VARCHAR2(20),
> part_image BLOB,
> part_desc CLOB,
> part_collateral BFILE
> ) ;
> ---------------------------------
>
> so, I open the scrip from PL/SQL+ 'File' menu - this loads script onto the
> "console", I press Enter then I go to 'File' menu again and
> I select 'Run'. At this moment I am getting "ORA-00933: SQL command not
> properly ended"
>
> thanks fro help
>
>
> "TurkBear" <noone_at_nowhere.com> wrote in message
> news:98nbdt0vibh7mqvjaqg9hiq5p487uk0oj7_at_4ax.com...
> >
> > Please post your script...its almost impossible to see errors unless we
 can see
> > the script..
> >
> > "Marek" <marekm@_NO_SPAM_frogware.com> wrote:
> >
> > >I have very simple SQL script (few queries) to execute from PLSQL+ ,
 each
> > >time I try to run it I am receiving this :
> > >
> > >"ORA-00933: SQL command not properly ended"
> > >
> > >I tried to end each query with semicolon, still the same. I tried
 without
> > >semicolon - no results.
> > >
> > >Could anybody tell me how to format SQL script toi be able execute it
 from
> > >PL/SQL + ?
> > >
> > >Thank you,
> > >Marek.
> > >
> >
> >
> >
> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
>
>
Received on Thu Apr 12 2001 - 13:38:39 CDT