Results for PRAGMA


1 to 20 of 315 results. Prev  Next
Results per page:  20 |  40  | 60


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

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)

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, 3 of 52

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

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

PL/SQL Language Elements, 40 of 52

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

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)

Native Dynamic SQL

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

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

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

PL/SQL Language Elements, 1 of 52

SELECT INTO StatementSERIALLY_REUSABLE Pragma

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

PL/SQL Language Elements, 1 of 52

Assignment StatementAUTONOMOUS_TRANSACTION Pragma

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SQL, 2 of 2

Pragmaspragma restrict_references(fetch_rows,WNDS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SQL, 2 of 2

Pragmaspragma restrict_references(bind_variable,WNDS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_UTILITY, 2 of 2

Pragmaspragma restrict_references(format_call_stack,WNDS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SQL, 2 of 2

Pragmaspragma restrict_references(execute_and_fetch,WNDS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SPACE, 2 of 2

Pragmaspragma restrict_references(free_blocks,WNDS);

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

PL/SQL Language Elements, 1 of 52

RAISE StatementRecords RESTRICT_REFERENCES Pragma

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_PIPE, 2 of 2

Pragmaspragma restrict_references(create_pipe,WNDS,RNDS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_OUTPUT, 2 of 2

Pragmaspragma restrict_references(disable,WNDS,RNDS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SQL, 2 of 2

Pragmaspragma restrict_references(last_row_count,RNDS,WNDS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_PIPE, 2 of 2

Pragmaspragma restrict_references(send_message,WNDS,RNDS);





Was this page helpful?

Integrated Cloud Applications & Platform Services