Re: executing sql code with SQLPlus

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.

-- 
Regards,
Frank van Bortel