Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-03113 with DEC3Encrypt

ORA-03113 with DEC3Encrypt

From: Bryce <spamtrap_at_berzerker-soft.com>
Date: Wed, 13 Jul 2005 11:31:03 -0400
Message-ID: <9acad1tkd1j9c2e49v26j05942kdrkujh5@4ax.com>


I have the following Stored Procedure, adapted from several examples:

CREATE OR REPLACE PROCEDURE "TEST_ENCRYPT" (input_string in VARCHAR2) as

   input_string2 VARCHAR2(16) :=
RPAD(input_string, 16);

   key_string          		VARCHAR2(16)  := 'scottscottscotts';
   encrypted_string         VARCHAR2(2048);
  

BEGIN
    dbms_obfuscation_toolkit.DES3Encrypt(

               input_string => input_string2, 
               key_string => key_string, 
               encrypted_string => encrypted_string );

      dbms_output.put_line('> encrypted hex value              : ' || 
                   rawtohex(UTL_RAW.CAST_TO_RAW(encrypted_string)));

END;
/

When using Oracle 9i (version 9.2.0.1), this works great.

However, when running in 9.2.0.6 (both Windows) I get: ORA-03113: end-of-file on communication channel

There doesn't appear to be any accompanying error messages. That's the one and only line that displays.

Thanks.

--
now with more cowbell
Received on Wed Jul 13 2005 - 10:31:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US