Skip to Main Content
Oracle
Live SQL
Help
Sign In
Home
SQL Worksheet
My Session
Previous Sessions
Utilization
NLS
Schema
Quick SQL
My Models
My Scripts
My Tutorials
Code Library
Code Library
Breadcrumb
Search
Area
All
PL/SQL General - 10
Category
All
Types
All
Tutorials
Scripts
Sort By
Date Added
Executions
Name
Likes
Results Per Page
60
120
180
240
300
360
420
480
540
600
Reset Search
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
38
6.3 years ago
Steven Feuerstein (Oracle)
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...
Script
deprecate,plw
1
17
5.5 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
16
5.5 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
1
10
6.6 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
4.3 years ago
Steven Feuerstein (Oracle)
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...
Script
warning,reserved word,keyword
0
9
4.3 years ago
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
4.3 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
3.2 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
4.3 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
4.3 years ago
Steven Feuerstein (Oracle)
row(s) 1 - 10 of 10