In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
Import paramikodef sshclient_execmd(hostname, port, username, password, execmd): paramiko
© 2024 shulou.com SLNews company. All rights reserved.