Re: Propblem with executing Oracle SQL scrip

That was exactly what I needed !!!

Thank you very much.

"Bart" <Bart_at_opcomp.demon.co.uk> wrote in message news:987101094.8417.0.nnrp-14.9e985e86_at_news.demon.co.uk...
> 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 - 15:07:19 CDT