如何正确调用 DBMS_OBFUSCATION_TOOLKIT.DESEncrypt ? (如果可能,不使用PL / SQL)
How to properly call DBMS_OBFUSCATION_TOOLKIT.DESEncrypt? (without using PL/SQL if possible)
select DBMS_OBFUSCATION_TOOLKIT.DESEncrypt('x','y') from dual;因为DESEncrypt重载不起作用:
doesn't work because DESEncrypt is overloaded:
ORA-06553: PLS-307: Too many declarations of "DESENCRYPT" match this call 06553. 00000 - "PLS-%s: %s" *Cause: *Action:有没有办法选择一个DESENCRYPT (可能是VARCHAR2变体)以避免这个错误?
Is there a way to choose one implementation of DESENCRYPT (possibly the VARCHAR2 variant) to avoid this error?
推荐答案这里你去,只是让它知道使用哪个重载param name!
here you go, just let it know which overload to use by supplying the param names!
select DBMS_OBFUSCATION_TOOLKIT.DesEncrypt(INPUT_STRING=>'11112abc',KEY_STRING=>'4578ccde') from dual ;返回
M5 w5Z
M5��w5Z
注意,您的密钥至少需要8个字节:
note, your key needs to be at least 8 bytes:
ORA-28234:key length too short ORA-06512:at SYS.DBMS_OBFUSCATION_TOOLKIT_FFI, line 21 ORA-06512:在SYS.DBMS_OBFUSCATION_TOOLKIT,行 126 28234. 00000 - 密钥长度太短 *原因:指定的密钥对算法来说太短。 DES 需要至少8个字节的密钥。三重DES需要在双键模式下至少为16个字节的密钥和三键模式中的24个字节。 *动作:指定一个较长的键。
ORA-28234: key length too short ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 21 ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 126 28234. 00000 - "key length too short" *Cause: The key specified is too short for the algorithm. DES requires a key of at least 8 bytes. Triple DES requires a key of least 16 bytes in two-key mode and 24 bytes in three-key mode. *Action: Specify a longer key.
它具有包装功能(如tony所示)
You may always try it with a wrapper function (as tony suggested)
create or replace function DesEncrypt(pinputString IN VARCHAR2 , pKeyString in VARCHAR2) RETURN varchar2 IS BEGIN return DBMS_OBFUSCATION_TOOLKIT.DesEncrypt(INPUT_STRING=>INPUTSTRING,KEY_STRING=>KEYSTRING); END DesEncrypt; / select DesEncrypt('11112abc' , '4578ccde') from dual ;
由于你在10g,你可能想使用DBMS_CRYPTO包 http ://www.stanford.edu/dept/itss/docs/oracle/10g/network.101/b10773/apdvncrp.htm
更多推荐
Oracle:如何调用重载过程?
发布评论