pl/sql compiler

[elaine3839]

Hi,

I'd like to check pl/sql syntax errors since they can't be trapped by exception handling in PL/SQL. So does Oracle has a PL/SQL compiler that allow me to do that? How about third party tool?

Thanks!

[pipo]

if you simply type your PL/SQL under SQL*Plus, you'll see if there is any compilation error ...

[elaine3839]

That's true. But if I don't run the individual script interactively, instead I run a script file which contains a lot of scripts. how can I catch it?

[pipo]

usually scripts are tested individually before being launched all together ... but well, AFAIK there is no external tool to check PL/SQL, so I'll guess you'll have to test each script :/

[tomate]

if you install it under sqlplus than make a spool in the script in it.
I hope i can help you