Parsing PL/SQL (in TOAD?)

[MattWoberts]

Hi,

Can anyone tell me whether it is possible to parse/verify PL/SQL in TOAD (or if any other Oracle S/w will do this)

Thanks!

 

[sem]

When I had a need in checking some &quot;generated&quot; code, I used a trick: enclosed my code into begin return; <code> end; and executed this block. Of course you should take into account offset caused by begin return;.

Regards, Dima

 

[deveshjogal]

Dima

Can u tell me What 'Begin return' syntax do?
So far I never used it.
It will addition to my knowledge.

Devesh

 

[sem]

In fact it does NOTHING! This was an aim to make Oracle to verify syntax while DOING NOTHING (probably dangerous). Of course, dbms_sql may be used, but DDL commands are executed during PARSE time, so even parsing may be not safe. Do you know another way to do it?

Regards, Dima

 

[MattWoberts]

This &quot;begin return&quot; thing is interesting. I'll have to give it a go and see what happens. Our SQL scripts generally contain a lot of one-off PL/SQL cursor loops that migrate data from format A to format B, and its frustrating that the only way to check for &quot;simple&quot; script errors is to run the script and see what happens!