TYPE emp_tab IS TABLE OF employees%ROWTYPE INDEX BY PLS_INTEGER */ĬREATE PROCEDURE wraptest AUTHID DEFINER IS * The PL/SQL source text of the following two CREATE statements will be wrapped. PL/SQL Source Text Wrapping with DBMS_DDL SubprogramsĮxample A-1 SQL File with Two Wrappable PL/SQL Units - The following statement will not change. PL/SQL Source Text Wrapping with PL/SQL Wrapper Utility For more information about PL/SQL compilation parameters, see "PL/SQL Units and Compilation Parameters". For more information about PERMIT_92_WRAP_FORMAT, see Oracle Database Reference. To prevent the 11.2 PL/SQL compiler from using wrapped packages that were compiled with the 9.2 PL/SQL compiler, set the PL/SQL compilation parameter PERMIT_92_WRAP_FORMAT to FALSE. The DBMS_DDL subprograms wrap the source text of single dynamically generated wrappable PL/SQL units.īoth the PL/SQL Wrapper utility and DBMS_DDL subprograms detect tokenization errors (for example, runaway strings), but not syntax or semantic errors (for example, nonexistent tables or views).īy default, the 11.2 PL/SQL compiler can use use wrapped packages that were compiled with the 9.2 PL/SQL compiler. The PL/SQL Wrapper utility wraps the source text of every wrappable PL/SQL unit created by a specified SQL file.
To produce a wrapped file, use either the PL/SQL Wrapper utility or a DBMS_DDL subprogram. A wrapped file can be moved, backed up, or processed by SQL*Plus or the Import and Export utilities. For high-assurance security, use Oracle Database Vault, described in Oracle Database Vault Administrator's Guide.Ī file containing wrapped PL/SQL source text is called a wrapped file.
0 kommentar(er)
