Code Library - Oracle Live SQL

Script

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...

raise,warning,plw

1 40

8.8 years ago Steven Feuerstein

Script

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...

12.2.0.1 DEPRECATE PRAGMA

0 21

8 years ago Sarah Hirschfeld (Oracle)

Script

12.2: Use DEPRECATE Pragma to Document Deprecated Units

New to 12.2, you can now use the DEPRECATE pragma to document that a program unit (e.g., entire pack...

deprecate,plw

1 17

8 years ago Steven Feuerstein

Script

Use Warnings to Identify NOCOPY Opportunities

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

WARNING,ERROR,plw,nocopy

1 14

6.8 years ago Steven Feuerstein

Script

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...

WARNING,ERROR,plw

1 10

9.1 years ago Steven Feuerstein

Script

Reserved words, keywords, and the ends of labeled blocks

This code accompanies a blog post by Bryn Llewellyn, PL/SQL Product Manager, with these three key ta...

warning,reserved word,keyword

0 9

6.8 years ago Oracle

Script

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 ...

WARNING,ERROR,plw,unreachable

0 6

6.8 years ago Steven Feuerstein

Script

Inlining Optimization and PL/SQL Warnings

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

inlining,warnings,subprograms

0 4

5.7 years ago Steven Feuerstein

Script

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...

error,warning,plw,runtime

0 2

6.8 years ago Steven Feuerstein

Script

Avoid Using Pre-Defined Names

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

error,warning,plw

0 1

6.8 years ago Steven Feuerstein