ZJS4sutKjJStYT2YsGf4Mfh8YOowgxDc7Z7WfC+5Vs7LeMVjaYLf9VAw/DdubCQDVGuPJby1 RdHE7X+X9dq0dYx9Bydq4h6frnD3S4WpKl7lCcAWvutNino76tIyrPjP1J6c2SS/zd9VjaOQĬREATE OR REPLACE FUNCTION fibonacci wrapped Z元sdcqGUS1Hoil/l7rHrSAppMlgj8OQcvUOUw8EAMdcEhWUGuVr1k7ZfPPr圜0CPuQYNVMN IswWo6UlLCCfDjMv8TRCThSol2dhohW7/sYpz+StjJY6lZN0bGCbvqei89EAaB1Cyzbs5tft */Īti2yLD3B+kU7XM0TVryX73L8xowg+lKLgwdNXRAAJn5B/5mc1dWMyeu2toxe3WQdE43ud4v * The PL/SQL source text of the following two CREATE statements Processing wraptest2.sql to bĬontents of b: SELECT COUNT(*) FROM EMPLOYEES Wrap the file wraptest.sql: > wrap iname=wraptest2.sql In SQL*Plus, Example A-3 runs the wrapped file b, creating the procedure wraptest and the function fibonacci selects the text of the subprograms (which is wrapped and therefore unreadable), and then invokes the subprograms.Įxample A-2 Wrapping File with PL/SQL Wrapper UtilityĪssume that the operating system prompt is >. The wrapped file shows that the utility deleted the comment that begins with - and wrapped (made unreadable) the PL/SQL source text of the procedure wraptest and the function fibonacci, but did not change the SELECT statement or the comment delimited by /* and */. The file also contains two comments and a SQL SELECT statement.Įxample A-2 uses the PL/SQL Wrapper utility to wrap wraptest2.sql and shows the wrapped file, b. For example: SQL> A-1 shows the text of a SQL file, wraptest2.sql, that contains two wrappable PL/SQL units-the procedure wraptest and the function fibonacci. You can run output_file as a script in SQL*Plus. This example specifies a different file extension for input_file and a different name for output_file: wrap iname=/mydir/myfile. Wrap iname=/mydir/myfile.sql oname=/mydir/b Therefore, these commands are equivalent: wrap iname=/mydir/myfile The default name of output_file is input_file. The default file extension for input_file is sql. If input_file is a wrapped file, then input_file and output_file have identical contents. 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 12.1 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.1 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 Comments
Leave a Reply. |