用wrap加密package異常的解決方法是什么

這期內(nèi)容當(dāng)中小編將會(huì)給大家?guī)碛嘘P(guān)用wrap加密package異常的解決方法是什么,文章內(nèi)容豐富且以專業(yè)的角度為大家分析和敘述,閱讀完這篇文章希望大家可以有所收獲。

創(chuàng)新互聯(lián)主營(yíng)景東網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營(yíng)網(wǎng)站建設(shè)方案,手機(jī)APP定制開發(fā),景東h5小程序開發(fā)搭建,景東網(wǎng)站營(yíng)銷推廣歡迎景東等地區(qū)企業(yè)咨詢

在windows下wrap 一個(gè)package的時(shí)候,不能成功,是怎么回事?
D:>dir *.sql
驅(qū)動(dòng)器 D 中的卷是 應(yīng)用盤
卷的序列號(hào)是 C4CF-9B46

D: 的目錄

2006-05-27 09:57 145,910 toms_dbms.sql
1 個(gè)文件 145,910 字節(jié)
0 個(gè)目錄 2,174,296,064 可用字節(jié)

D:>wrap iname=toms.dbms.sql
kgepop: no error frame to pop to for error 1801

D:>

同樣的package在aix 5.2下加密的時(shí)候也報(bào)錯(cuò),但可以安裝,內(nèi)容如下

/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:

<an identifier> <a double-quoted delimited-identifier>
The symbol "<an identifier> 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>

有誰知道是怎么回事?難道是包體太長(zhǎng)了? 以前包體在2000多行的時(shí)候沒事,現(xiàn)在增加到3000多行了
就不行了。^|^


經(jīng)過查找資料發(fā)現(xiàn),原來在windows下,是因?yàn)榭蛻舳俗址膯栴},在CMD下執(zhí)行
set nls_lang=american_america.usascii7

然后,再運(yùn)行OK了.

而如下的錯(cuò)誤信息,是因?yàn)椴糠諷QL語法不支持導(dǎo)致的。加上edebug=wrap_new_sql[強(qiáng)制支持所有語法]就OK了。
PSU(103,1,269,46):Encountered the symbol "SQL" when expecting one of the followi
ng:

<an identifier> <a double-quoted delimited-identifier>
The symbol "<an identifier> 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.


附:成功WRAP的過程

Microsoft Windows XP [版本 5.1.2600]
(C) 版權(quán)所有 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:

<an identifier> <a double-quoted delimited-identifier>
The symbol "<an identifier> 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:>

上述就是小編為大家分享的用wrap加密package異常的解決方法是什么了,如果剛好有類似的疑惑,不妨參照上述分析進(jìn)行理解。如果想知道更多相關(guān)知識(shí),歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道。

文章題目:用wrap加密package異常的解決方法是什么
文章出自:http://muchs.cn/article4/jiohie.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供外貿(mào)網(wǎng)站建設(shè)、自適應(yīng)網(wǎng)站軟件開發(fā)、面包屑導(dǎo)航、全網(wǎng)營(yíng)銷推廣、搜索引擎優(yōu)化

廣告

聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)

商城網(wǎng)站建設(shè)