Oracle Live SQL - Code Library

Automatically Detect Exception Handlers That ''Swallow Up'' Errors

Use compile time warnings to be warned if the compiler has identified an exception handler that does...

Script raise,warning,plw

1 35

5.9 years ago Steven Feuerstein (Oracle)

Deprecation of a PL/SQL Package

This example shows the deprecation of a PL/SQL package as a whole. Warnings will be issued for any r...

Script 12.2.0.1 DEPRECATE PRAGMA

0 15

5.1 years ago Oracle

Improve Code QA by Treating Warning as Error

Use compile-time warnings to give you additional feedback on ways to improve your code. Set a partic...

Script WARNING,ERROR,plw

0 10

6.2 years ago Steven Feuerstein (Oracle)

Use Warnings to Identify NOCOPY Opportunities

With OUT and IN OUT parameters, you can benefit from adding the NOCOPY clause, which asks the compil...

Script WARNING,ERROR,plw,nocopy

1 10

3.9 years ago Steven Feuerstein (Oracle)

Find Unreachable Code with PL/SQL Warnings

Oh, so you think you know what's going on in your code base? You think all that code that you wrote ...

Script WARNING,ERROR,plw,unreachable

0 6

3.9 years ago Steven Feuerstein (Oracle)

Inlining Optimization and PL/SQL Warnings

This script turns on inlining (optimization level 3) and also compile-time warnings. The warning mes...

Script inlining,warnings,subprograms

0 4

2.8 years ago Steven Feuerstein (Oracle)

Use Compile-Time Warnings to Detect Runtime Errors

This is one of my favorite warnings: PLW-6017. Something bad is your way coming! This catch-all warn...

Script error,warning,plw,runtime

0 2

3.9 years ago Steven Feuerstein (Oracle)

Avoid Using Pre-Defined Names

Use the PL/SQL compile time warnings system to detect when you are using names of pre-defined elemen...

Script error,warning,plw

0 0

3.9 years ago Steven Feuerstein (Oracle)