Turn off compiler hints

G

Gaz

Member²
Hi

I'm having trouble where to turn off compiler hints when compiling packages. I'm getting lots of PLW warnings that don't concern me - is there an option for turning this off?

I looked at Tools > Preferences > Oracle > Hints {Profiler Hints} but this doesn't have anything that looks likely.

I've also tried to turn off warning at db level, but to no avail:
ALTER SESSION SET PLSQL_WARNINGS='DISABLE:ALL';

Many thanks in advance

Gaz
 
Thanks for the response. Is that a version 8 feature? I've got version 7 and "Compiler" doesn't appear to have an entry.

Cheers

Gaz
 
Sorry, yes, I believe that's a version 8 feature.

You may be able to use the ALTER SESSION command in the AfterConnect.sql file:
Marco Kalter said:
you can edit the AfterConnect.sql file in the PL/SQL Developer installation directory to execute SQL and PL/SQL commands for each session that is created in PL/SQL Developer.
Click to expand...
 
Brilliant - good call. We're waiting for our company to get version 8 approved before we're allowed to install.

Turns out the company standard wrapped package comes with
"ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';" in the AfterConnect.sql file - which would explain a thing or two!

Thanks for the help.

Gaz
 
Hey

I've noted that changing the session as above means that I'm not getting compilation warnings unfortunately. I can't seem to find a combination of manipulating PLSQL_WARNINGS that will remove the Hint, and keep all the (important) compilation errors.

e.g. PLSQL_WARNINGS = 'ENABLE:SEVERE', 'DISABLE:INFORMATIONAL', 'DISABLE:PERFORMANCE';

Wondering if there's something else I could set?

Cheers

Gaz
 
You must log in or register to reply here.
Back
Top