Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What is the solution to encrypting package exceptions with wrap

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/01 Report--

In this issue, Xiaobian will bring you about the solution to the package exception with wrap encryption. The article is rich in content and analyzed and described from a professional perspective. After reading this article, I hope you can gain something.

When wrapping a package under windows, it doesn't succeed. What's going on?

D:>dir *.sql

The volumes in drive D are application disks

The serial number of the volume is C4CF-9B46.

D: Directory of

2006-05-27 09:57 145,910 toms_dbms.sql

1 file 145,910 bytes

0 directories 2,174,296,064 bytes available

D:>wrap iname=toms.dbms.sql

kgepop: no error frame to pop to for error 1801

D:>

The same package in aix 5.2 encryption also error, but can be installed, as follows

/oracle> wrap iname=1.sql

PL/SQL Wrapper: Release 9.2.0.6.0- 64bit Production on Sat May 27 10:19:41 2006

Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.

Processing 1.sql to 1.plb

PSU(103,1,269,46):Encountered the symbol "SQL" when expecting one of the following:

The symbol " was inserted before "SQL" to continue.

PL/SQL Wrapper error: Compilation error(s) for:

create or replace package body toms_dbms

Outputting source and continuing.

/oracle> sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Sat May 27 10:19:48 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn user/pwd

Connected.

SQL> start 1.plb

Package created.

Package body created.

SQL> exit

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

With the Partitioning and Real Application Clusters options

JServer Release 9.2.0.6.0 - Production

/oracle>

Does anyone know what's going on? Is the envelope too long? In the past, when the envelope was more than 2000 lines, it was fine, but now it has increased to more than 3000 lines.

Not anymore.^|^

After searching the data, it was found that under windows, it was because of the problem of client character set, executed under CMD.

set nls_lang=american_america.usascii7

Then, run OK again.

The following error messages are caused by some SQL syntax that is not supported. Add edebug=wrap_new_sql[force support for all syntax] and it's OK.

PSU(103,1,269,46):Encountered the symbol "SQL" when expecting one of the followi

ng:

The symbol " was inserted before "SQL" to continue.

PL/SQL Wrapper error: Compilation error(s) for:

create or replace package body toms_dbms

Outputting source and continuing.

The process of successful WRAP

Microsoft Windows XP [version 5.1.2600]

(C)Copyright 1985-2001 Microsoft Corp.

D:>set nls_lang=american_america.usascii7

D:>wrap iname=toms_dbms.sql;

PL/SQL Wrapper: Release 9.2.0.1.0- Production on Sat May 27 12:24:00 2006

Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.

PL/SQL Wrapper error: Couldn't open input file toms_dbms.sql;

D:>wrap iname=toms_dbms.sql

PL/SQL Wrapper: Release 9.2.0.1.0- Production on Sat May 27 12:24:14 2006

Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.

Processing toms_dbms.sql to toms_dbms.plb

PSU(103,1,269,46):Encountered the symbol "SQL" when expecting one of the followi

ng:

The symbol " was inserted before "SQL" to continue.

PL/SQL Wrapper error: Compilation error(s) for:

create or replace package body toms_dbms

Outputting source and continuing.

D:>wrap iname=toms_dbms.sql edebug=wrap_new_sql

PL/SQL Wrapper: Release 9.2.0.1.0- Production on Sat May 27 12:25:03 2006

Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.

Processing toms_dbms.sql to toms_dbms.plb

D:>

The above is what is the solution to wrap encryption package exception shared by Xiaobian for everyone. If there is a similar doubt, please refer to the above analysis for understanding. If you want to know more about it, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report