You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for PRAGMA


1 to 20 of 292 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 46 of 52

SERIALLY_REUSABLE PragmaThe pragma SERIALLY_REUSABLE lets you mark a package as serially reusable. You can so mark a

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 40 of 52

RESTRICT_REFERENCES Pragmais 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

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 1 of 52

EXCEPTION_INIT PragmaExceptions EXECUTE IMMEDIATE Statement

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 16 of 52

EXCEPTION_INIT PragmaThe 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".

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 3 of 52

AUTONOMOUS_TRANSACTION PragmaThe AUTONOMOUS_TRANSACTION pragma instructs the PL/SQL compiler to mark a routine as autonomous

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Methods: Using PL/SQL

Pragma RESTRICT_REFERENCESUser'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,

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Native Dynamic SQL

Using Pragma RESTRICT_REFERENCESthe pragma RESTRICT_REFERENCES. The pragma asserts that a function does not read and/or write

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00127 Pragma string is not a supported pragmaCause: 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.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-04100 to ORA-07499

ORA-06538 statement violates string RESTRICT_REFERENCES pragmaspecified (in the pragma RESTRICT_REFERENCES directive) for the module executing the statement. Action

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00128 Illegal number of arguments for pragma stringCause: 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

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Handling PL/SQL Errors

Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INITOTHERS 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

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00109 unknown exception name ' string ' in PRAGMA EXCEPTION_INITCause: 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.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00701 illegal ORACLE error number string for PRAGMA EXCEPTION_INITCause: The error number passed to an EXCEPTION_INIT pragma was out of range. The error number must

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00710 PRAGMA AUTONOMOUS_TRANS*Action cannot be declared hereCause: 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.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00132 Pragma RESTRICT_REFERENCES does not support stringCause: 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

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

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

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00452 Subprogram ' string ' violates its associated pragmaby 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.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00711 PRAGMA AUTONOMOUS_TRANS*Action cannot be declared twiceCause: The PRAGMA was declared twice in the same block. Action: Remove the duplicate declaration of the PRAGMA.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 1 of 52

Assignment StatementAUTONOMOUS_TRANSACTION Pragma

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 1 of 52

SELECT INTO StatementSERIALLY_REUSABLE Pragma