Re: Propblem with executing Oracle SQL scrip

I have tried without ';' - no results, always the same message : "ORA-00933: SQL command not properly ended"

regards,
Marek

"TurkBear" <noone_at_nowhere.com> wrote in message news:7brbdt8i0r30vcr90s3sjt4l8m5l9vcqn2_at_4ax.com...
>
> Try it without the final ;
>
>
> "Marek" <marekm@_NO_SPAM_frogware.com> wrote:
>
> >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! =-----
> >
>
>
>
> -----= 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:23:45 CDT