Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: executing sql code with SQLPlus

Re: executing sql code with SQLPlus

From: Vince <vincent_at_>
Date: Tue, 10 May 2005 10:27:06 +0200
Message-ID: <vvr081lt9m8dmb40k4c6ts5djt6te6lscm@4ax.com>


On Tue, 10 May 2005 00:09:15 +0200, "Martin Weber" <mweber_at_netbi.de> wrote:

>Hi Vince,
>did you have a line with a single / at the end of your code ?
>To me it sounds like u missed this point. Then your code will be processed
>and you can retrieve error message with
>show errors command.
>
>greetings
>Martin
>
>"Vince .>" <vincent@<remove> schrieb im Newsbeitrag
>news:v1uu719dmddcblrke4q5tb7imhssr6lsq3_at_4ax.com...
>>
>> Hi there !
>>
>> I try to execute PL/SQL script from a file using the SQLPlus command
>> shell. But it doesn't seem to execute the script that might be buggy
>> (despite the fact, I've tested it in the SQLWorkSheet), I removed all
>> the blank lines that may cause SQLPlus to down..
>> is there any way to have error feedbacks on what can occur during file
>> parsing ?
>>
>> thanks a lot :)
>> ++
>> Vince
>

YES !!! that's it !! I didn't know that I needed a \ at the end of my script. Now, it runs properly :D

Thanks a lot :D
++
Vince Received on Tue May 10 2005 - 03:27:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US