Tag Archives: quick tip

Update to my earlier #quicktip on setting #plsql scope and warnings.

Posted on February 23, 2018 by rlockard

I noticed a error in my code for setting PLSCOPE_SETTINGS and PLSQL_WARNINGS. QuicTip Logon.sql What I did was get the instance name out of v$instance to figure out if I was connecting to a production environment or one of the lower environments. The … Continue reading →

Posted in Database Stuff, Life of a Oracle DBA, PL/SQL | Tagged logon.sql, oracle, pl/sql, PLSCOPE, PLSCOPE_SETTINGS, PLSQL_WARNINGS, quick tip, quicktip, sys_context | Leave a comment