Re: Propblem with executing Oracle SQL scrip

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:02:02 CDT