Pl Sql Unwrapping Tools
Followup January 07, 2002 - 12:45 pm UTC you run func1_wrap.sql, you deliver func1_wrap.sql. You keep func1.sql in case you ever need to modify the source code.
15.4 Wxga Acer Crystalbrite Lcd Driver Windows 7. Take this for example: ops$tkyte@ORA817DEV.US.ORACLE.COM>@test ops$tkyte@ORA817DEV.US.ORACLE.COM>create or replace procedure p 2 as 3 begin 4 dbms_output.put_line( 'Hello world' ); 5 end; 6 / Procedure created. Ops$tkyte@ORA817DEV.US.ORACLE.COM>select text from user_source where name= 'P'; TEXT ----------------------------------------------------------------------------------------------------------------------------------- procedure p as begin dbms_output.put_line( 'Hello world' ); end; now you see it. Ops$tkyte@ORA817DEV.US.ORACLE.COM>host wrap iname=test.sql oname=test_wrap.sql PL/SQL Wrapper: Release 8.1.7.2.0 - Production on Mon Jan 07 12: Copyright (c) Oracle Corporation 1993, 2000. All Rights Reserved. Processing test.sql to test_wrap.sql ops$tkyte@ORA817DEV.US.ORACLE.COM>@test_wrap.sql ops$tkyte@ORA817DEV.US.ORACLE.COM>create or replace procedure p wrapped 2 0 3 abcd 4 abcd 5 abcd 6 abcd 7 abcd 8 abcd 9 abcd 10 abcd 11 abcd 12 abcd 13 abcd 14 abcd 15 abcd 16 abcd 17 abcd 18 3 19 7 21 1 22 4 23 0 24 4 25 2:e: 26 1P: 27 1DBMS_OUTPUT: 28 1PUT_LINE: 29 1Hello world: 30 0 31. 86 / Procedure created.
And now you don't ops$tkyte@ORA817DEV.US.ORACLE.COM>select text from user_source where name = 'P'; TEXT ----------------------------------------------------------------------------------------------------------------------------------- procedure p wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 7 8106000 1 4 0 4 2:e: 1P: 1DBMS_OUTPUT: 1PUT_LINE: 1Hello world: 0. I must have missed the error msg the first time, since it created the function, abeit with errors. PL/SQL Wrapper: Release 8.1.7.0.0 - Production on Tue Jan 08 09: Copyright (c) Oracle Corporation 1993, 2000. All Rights Reserved. Processing encrypt.sql to encrypt.plb PSU(103,1,1,56):Encountered the symbol ' when expecting one of the following:. @%; is authid deterministic parallel_enable as character PL/SQL Wrapper error: Compilation error(s) for: CREATE OR REPLACE function encrypt Outputting source and continuing.
Unwrapping 10G wrapped PL/SQL 30. By Anton Scheffer on February 3, 2009 Oracle, PL/SQL. Share this on. There are PL/SQL unwrapping tools available. Audit Tools; Default Password. Pete Finnigan's Oracle Security Weblog. Unwrapping and the paper I wrote a few years ago for the How to unwrap PL/SQL that i.
It seems I created the source on my NT machine, FTP'd the source to the UNIX box, and ran it there. The wrap program seemd to choke on the windows return chars. I removed them via VI and all is well. I created a procedure, i was able to wrap the code. I logged in thru OEM as sysdba, i am not able to see the code. Upto this level it is fine. Glen Matlock on this page. Now i executed the procedure, the procedure takes around 15 minutes to complete.