It seems that the encrypted file is almost twice the size of the original file if there are Chinese characters After encryption. In addition, the execution speed of the encrypted script is several times slower, which may be 10 times slower. I don't know why.
UnencryptedCodeAvailable, but PLB code encrypted with wrap cannot pass the compiling environment:
Oracle9201 Window XP partition sion
The encryption command is as follows:
I tried the following two methods:
Method 1:
Set nls_lang = american_america.we8iso8859p1
Wrap INAME = lwsf_manage_packagehead. SQL edebug = wrap_new_ SQL
Pause
Wrap INAME = lwsf_manage_packagebody. SQL edebug = wrap_new_ SQL
Pause
PLB file generated successfully after Encryption
Method 2:
Set nls_lang = american_america.usacii7
Wrap INAME = lwsf_manage_packagehead. SQL edebug = wrap_new_ SQL
Pause
Wrap INAME = lwsf_manage_packagebody. SQL edebug = wrap_new_ SQL
Pause
PLB file generated successfully after Encryption
However, the following error message is generated when PLB is loaded:
SQL> @ lwsf_manage_packagehead.plb
ProgramThe package has been created.
SQL> @ lwsf_manage_packagebody.plb;
Warning: The created package contains a compilation error.
SQL> show errors
Package body pkg_lwsf_manage error:
Line/COL Error
-------------------------------------------------------------------------
759/5 PL/SQL: SQL statement ignored
762/54 PL/SQL: ORA-00905: Missing keywords
831/5 PL/SQL: SQL statement ignored
852/61 PL/SQL: ORA-01747: invalid user. Table. column, table. column, or column type
1170/5 PL/SQL: SQL statement ignored
1171/63 PL/SQL: ORA-00933: SQL command ended incorrectly
3383/5 PL/SQL: SQL statement ignored
3419/17 PL/SQL: ORA-00917: comma missing
3817/5 PL/SQL: SQL statement ignored
3843/33 PL/SQL: ORA-03001: unexecuted features
3903/5 PL/SQL: SQL statement ignored
Line/COL Error
-------------------------------------------------------------------------
3914/4 PL/SQL: ORA-00911: invalid characters
4492/5 PL/SQL: SQL statement ignored
4515/6 PL/SQL: ORA-00911: invalid characters
4661/5 PL/SQL: SQL statement ignored
4676/62 PL/SQL: ORA-00923: expected from keyword not found
SQL> spool off;
Set nls_lang = american_america.we8iso8859p1
Wrap INAME = lwsf_manage_packagehead. SQL edebug = wrap_new_ SQL
Pause
Wrap INAME = lwsf_manage_packagebody. SQL edebug = wrap_new_ SQL
Pause
The encrypted file PLB can be seen in Chinese. It is not garbled!
Set nls_lang = american_america.zhs16gbk
Wrap INAME = lwsf_manage_packagehead. SQL edebug = wrap_new_ SQL
Pause
Wrap INAME = lwsf_manage_packagebody. SQL edebug = wrap_new_ SQL
Pause
All code compilation passes