12/24/2023 0 Comments Db text procedureSELECT * BULK COLLECT INTO all_emps FROM employees įOR i IN 1.10 LOOP /* C style in pl/sql source */ĭBMS_OUTPUT.PUT_LINE('Emp Id: ' || all_emps(i).employee_id) ĪUTHID CURRENT_USER - PL/SQL style comment inside fibonacci function spec TYPE emp_tab IS TABLE OF employees%ROWTYPE INDEX BY PLS_INTEGER */ĬREATE PROCEDURE wraptest AUTHID CURRENT_USER /* C style comment in procedure declaration */ IS * The PL/SQL source text of the following two CREATE statements will be wrapped. The following statement will not change. The file also contains comments and a SQL SELECT statement. This example shows the text of a SQL file, wraptest2.sql, that contains two wrappable PL/SQL units-the procedure wraptest and the function fibonacci. For more information about PL/SQL compilation parameters, see " PL/SQL Units and Compilation Parameters".Įxample A-1 SQL File with Two Wrappable PL/SQL Units For more information about PERMIT_92_WRAP_FORMAT, see Oracle Database Reference. To prevent the 12.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 12.2 PL/SQL compiler can 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |