Procedures for Embedding HTML in PL/SQL. A clear delegation of work exists between the HTML and PL/SQL in your company's Web pages: PL/SQL code fetches and manipulates data from SQL databases, and ...

When you use SELECT in a PL/SQL block, it’s important to make sure that exactly one row will always be returned by your query. If more than one row is returned, the TOO_MANY_ROWS exception occurs.

The EXECUTE statement cannot be stored as part of an SQL Procedure Pass-Through Facility query in a PROC SQL view.