Precautions for wrap encryption (Chinese Character encryption)

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.