Database Reference
In-Depth Information
DBMS_WARNINGS
. Use this package to enable or disable
PL/SQL compilation warnings. The PLSQL_WARNINGS database
configuration parameter performs the same function.
UTL_COMPRESS
. Allows data compression.
UTL_MAIL
. Simplifies e-mail from within PL/SQL such that
protocol detail is no longer required.
24.10 Metadata Views
This section simply describes metadata views applicable to PL/SQL objects.
Chapter 19 describes the basis and detail of Oracle Database metadata
views.
USER_OBJECTS
. Shows all object types. A good method of search-
ing for PL/SQL objects such as procedures, functions, and triggers.
USER_PROCEDURES
. Shows procedure details.
USER_TRIGGERS
. Shows trigger details.
USER_TRIGGER_COLS
. Trigger column usage.
USER_SOURCE
. Stored blocks source code.
USER_ERRORS
. Most recent errors. When compiling a procedure
with an error, either access USER_ERRORS or type the command
SHOW ERRORS into SQL*Plus.
This chapter has described the basics of PL/SQL as a programming lan-
guage for constructing database stored procedures. Additionally, this chap-
ter ends this topic covering Oracle SQL for Oracle Database 10
g
. I hope
you have enjoyed reading this topic as much as I have enjoyed writing it.