Re: Propblem with executing Oracle SQL scrip

From: Marek <marekm_at__NO_SPAM_frogware.com>
Date: Thu, 12 Apr 2001 13:34:00 -0400
Message-ID: <kFlB6.187443$Z2.2265369@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 - 12:34:00 CDT