终于改出了能超过4000字的unwrap

〇〇

fuyuncat更新了，可以同时解多种，估计是用system("")实现的，因为fy.ocy实际是可执行文件。
另外，他坚持使用debug编译

http://www.hellodba.com/Download/fyunwrap_upgrade.html

st8117

楼主
sys.idltranslate这个表我怎么没找到啊？
请指教。。

〇〇

这个表手工建立的

ZALBB

CREATE OR REPLACE FUNCTION dl2ml(HY IN VARCHAR)
RETURN VARCHAR
AS
X VARCHAR(2);
BEGIN
SELECT
CASE
WHEN HY >='01' AND HY<= '05' THEN 1
WHEN HY >='06'
AND HY<= '11' THEN 2
WHEN HY >='13' AND HY<= '43' THEN 3
WHEN HY >='44' AND HY<= '46' THEN 4
WHEN HY >='47' AND HY<= '50' THEN
5
WHEN HY >='51' AND HY<= '59' THEN 6
WHEN HY >='60' AND HY<= '62' THEN 7
WHEN HY  ='63' OR  HY = '65' THEN 8
WHEN HY >='66' AND
HY<= '67' THEN 9
WHEN HY >='68' AND HY<= '71' THEN 10
WHEN HY >='72' AND HY<= '72' THEN 11
WHEN HY >='73' AND HY<= '74' THEN 12
WHEN
HY >='75' AND HY<= '78' THEN 13
WHEN HY >='79' AND HY<= '81' THEN 14
WHEN HY >='82' AND HY<= '83' THEN 15
WHEN HY >='84' AND HY<=
'84' THEN 16
WHEN HY >='85' AND HY<= '87' THEN 17
WHEN HY >='88' AND HY<= '92' THEN 18
WHEN HY >='93' AND HY<= '98' THEN 19
ELSE
NULL
END
INTO X FROM DUAL;
RETURN X;
END;


D:\oracle\product\10.2.0\db_1\BIN>wrap iname=H:\JOB\NC\dl2ml.log oname=H:\JOB\NC\dl2ml.plb

PL/SQL Wrapper: Release 10.2.0.4.0- Production on Wed Feb 03 15:38:26 2010

Copyright (c) 1993, 2004, Oracle.  All rights reserved.

Processing H:\JOB\NC\dl2ml.log to H:\JOB\NC\dl2ml.plb

D:\oracle\product\10.2.0\db_1\BIN>

SYS@bi>start H:\JOB\NC\dl2ml.plb

Function created.

Elapsed: 00:00:00.03
SYS@bi>exec unwrap('SYS','DL2ML','FUNCTION');
BEGIN unwrap('SYS','DL2ML','FUNCTION'); END;

*
ERROR at line 1:
ORA-29261: bad argument
ORA-06512: at "SYS.UTL_ENCODE", line 29
ORA-06512: at "SYS.UTL_ENCODE", line 251
ORA-06512: at "SYS.UNWRAP", line 44
ORA-06512: at line 1

Elapsed: 00:00:00.01

何故？

it_toad

mark

nathanleewei

原帖由 〇〇 于 2009-12-26 19:38 发表
fuyuncat更新了，可以同时解多种，估计是用system("")实现的，因为fy.ocy实际是可执行文件。
另外，他坚持使用debug编译

http://www.hellodba.com/Download/fyunwrap_upgrade.html

出现this application has failed to start becasuse OCI.dll was not found
re-installing the application may fix this problem
我本地的oracle（OCI.dll）完好 oracle_home /bin也在path上

请问如何解决

anubis

深入学习一下

谢谢

culturenet

出现如下状况，不知何故

ORA-29261: 参数无效
ORA-06512: 在 "SYS.UTL_ENCODE", line 29
ORA-06512: 在 "SYS.UTL_ENCODE", line 251
ORA-06512: 在 "SYS.UNWRAP", line 50
ORA-06512: 在 line 2

[ 本帖最后由 culturenet 于 2010-4-17 16:27 编辑 ]

尛样儿

我先顶你，然后再学习。

〇〇

原帖由 nathanleewei 于 2010-4-8 19:21 发表


出现this application has failed to start becasuse OCI.dll was not found
re-installing the application may fix this problem
我本地的oracle（OCI.dll）完好 oracle_home /bin也在path上

请问如何解决

可能是32、64位的问题，安装一个32位的客户端