Re: executing sql code with SQLPlus

On Mon, 09 May 2005 17:09:16 +0200, Frank van Bortel <fvanbortel_at_netscape.net> wrote:

I tried the 'show errors' in my PL block, but nothing appears..it stays up with a number line as if it didn't execute anything :-/

++
Vince

>Vince <vincent@ wrote:
>> 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
>
>show error
>
>And blank lines are a bad habit, not just because they can
>cause errors in scripts.
>If you insist, use a double minus (--) in the first two positions
>of a line, indicating a comment line.
Received on Mon May 09 2005 - 10:25:34 CDT