Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_CRYPTO for BLOB Encryption using VB6
DBMS_CRYPTO for BLOB Encryption using VB6 [message #190840] Fri, 01 September 2006 09:11
itshastra
Messages: 1
Registered: September 2006
Location: Navi Mumbai
Junior Member
Hello Friends,

I am getting one problem while using DBMS_CRYPTO for BLOB encryption using VB6.

I am trying this :

sql = "update ora10gtest set encr_blob = (select dbms_crypto.encrypt(org_blob, 4358, utl_i18n.string_to_raw('yogeshchaudhari1', 'AL32UTF8') ) from ora10gtest where test_id = " & p_intTestId & ") where test_id = " & p_intTestId

cnnDB.Execute sql

But, I am getting following error:

[Oracle][ODBC][Ora]ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 54701, maximum: 2000)

Please guide me on this.

Thanks,
Yogesh
Previous Topic: V$tables
Next Topic: Help with CASE statement
Goto Forum:
  


Current Time: Sun Dec 04 02:46:59 CST 2016

Total time taken to generate the page: 0.08904 seconds