How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
SERIALLY_REUSABLE Pragma → The pragma SERIALLY_REUSABLE lets you mark a package as serially reusable. You can so mark a
RESTRICT_REFERENCES Pragma → is parsed). To check for violations of the rules, you can use the pragma (compiler directive … ) RESTRICT_REFERENCES. The pragma asserts that a function does not read and/or write database tables and/or
EXCEPTION_INIT Pragma → Exceptions EXECUTE IMMEDIATE Statement
EXCEPTION_INIT Pragma → The pragma EXCEPTION_INIT associates an exception name with an Oracle error number. That lets you … OTHERS handler. For more information, see "Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INIT".
AUTONOMOUS_TRANSACTION Pragma → The AUTONOMOUS_TRANSACTION pragma instructs the PL/SQL compiler to mark a routine as autonomous
Pragma RESTRICT_REFERENCES → User's Guide and Reference. You use the pragma (compiler directive) RESTRICT_REFERENCES to enforce … : CREATE TYPE DataStream AS OBJECT (.... PRAGMA RESTRICT_REFERENCES (DataStreamMax, WNDS, WNPS … ... PRAGMA RESTRICT_REFERENCES (ds_findmin, WNDS, WNPS)... end; In addition to WNDS and WNPS, it … RESTRICT_REFERENCES pragma,
Using Pragma RESTRICT_REFERENCES → the pragma RESTRICT_REFERENCES. The pragma asserts that a function does not read and/or write
PLS-00127 Pragma string is not a supported pragma → Cause: The named pragma (compiler directive) is not among those supported by PL/SQL. The pragma … name might be misspelled, or the pragma syntax might be faulty. Action: Check the spelling of the pragma name, and make sure the proper syntax was used.
ORA-06538 statement violates string RESTRICT_REFERENCES pragma → specified (in the pragma RESTRICT_REFERENCES directive) for the module executing the statement. Action
PLS-00128 Illegal number of arguments for pragma string → Cause: The number of arguments (actual parameters) passed to the named pragma (compiler directive … ) is incorrect. A required argument was omitted from the argument list, or the pragma syntax is faulty
Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INIT → OTHERS handler or the pragma EXCEPTION_INIT. A pragma is a compiler directive that is processed at … compile time, not at run time. In PL/SQL, the pragma EXCEPTION_INIT tells the compiler to associate … , the one on top is the one that you can trap and handle. You code the pragma EXCEPTION_INIT in the … declarative
PLS-00109 unknown exception name ' string ' in PRAGMA EXCEPTION_INIT → Cause: No declaration for the exception name referenced in an EXCEPTION_INIT pragma was found … within the scope of the pragma. Action: Make sure the pragma follows the exception declaration and is within the same scope.
PLS-00701 illegal ORACLE error number string for PRAGMA EXCEPTION_INIT → Cause: The error number passed to an EXCEPTION_INIT pragma was out of range. The error number must
PLS-00710 PRAGMA AUTONOMOUS_TRANS*Action cannot be declared here → Cause: The PRAGMA was declared in an inappropriate context. This PRAGMA has to be declared in the … declarative section of a procedure, a function, a top level anonymous block. Action: Remove or relocate the misplaced pragma.
PLS-00132 Pragma RESTRICT_REFERENCES does not support string → Cause: One of the parameters passed to pragma RESTRICT_REFERENCES was not among the following, as … required: WNDS, WNPS, RNDS, RNPS. The parameter might be misspelled, or the pragma syntax might be
PLS-00115 this PRAGMA must follow the declaration of ' string ' → Cause: The pragma refers to a PL/SQL object that was not declared or is not within the scope of the … reference. Identifiers must be declared before they are used in a pragma; forward references are
PLS-00452 Subprogram ' string ' violates its associated pragma → by coding a RESTRICT_REFERENCES pragma in the package specification. The pragma, which is used to … database tables, public packaged variables, or both. A SQL statement that violates the pragma will … cause a compilation error. Action: Raise the purity level of the function, or relax the pragma restrictions.
PLS-00711 PRAGMA AUTONOMOUS_TRANS*Action cannot be declared twice → Cause: The PRAGMA was declared twice in the same block. Action: Remove the duplicate declaration of the PRAGMA.
Assignment Statement → AUTONOMOUS_TRANSACTION Pragma