My Oracle Support Banner

Primary Note for Oracle PL/SQL API (Doc ID 1136485.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

PL/SQL - Version 8.1.7.4 and later
Information in this document applies to any platform.

Purpose

This PL/SQL primary note provides information on the relevant articles associated with the following topics:


1.   UTL_SMTP / UTL_MAIL
2.   UTL_FILE
3.   UTL_HTTP
4.   External Procedures
5.   Native Compilation
6.   Dynamic SQL / Native Dynamic SQL
7.   Large Objects (LOBS)
8.   Collections, Object Types & Bulk Collect
9.   PLS-801 Error With Different Arguments
10. ORA-06502 Errors.
11. PLS-201 / PLS-306 / PLS-320 Errors
12. ORA-04068 / ORA-04065 / ORA-06508 Related Errors
13. "Bugs, Fixed Versions and Workarounds in PL/SQL"
14. DBMS_EPG

15. ORA-24247 Errors

16. ORA-04091 Mutating Table Error

17. ORA-942 / ORA-1031 / PLS-201 / ORA-28111 in PL/SQL, works in SQL*Plus

 

 

If you have found another note which is not listed but solved your problem related to topics highlighted here, please add a comment so that we can add the link to our note and help maintain the currency of this document.

Scope

The intended audience is for users of the PL/SQL API. The notes listed are references for novice to experienced users.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 1. UTL_SMTP / UTL_MAIL 
 
2. UTL_FILE
 
3. UTL_HTTP
 
4. External Procedures
 
5. Native Compilation
 
6. Dynamic SQL / Native Dynamic SQL
 
7. LOBS
 
8. Collections, Object Types & Bulk Collect
 
9.  PLS-801 Error With Different Arguments
  
10. ORA-06502 errors
 
11. PLS-201 / PLS-306 / PLS-320
 
12. ORA-04068 / ORA-04065 / ORA-06508 Related Errors
 
13.  "Bugs, Fixed Versions and Workarounds in PL/SQL"
 
14. DBMS_EPG
 15. ORA-24247 Errors
 16. ORA-04091 Mutating Table Error
 17. ORA-942 / ORA-1031 /  PLS-201 / ORA-28111 in PL/SQL, works in SQL*Plus
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.