Re: ORA-03113 with DEC3Encrypt

In article <9acad1tkd1j9c2e49v26j05942kdrkujh5_at_4ax.com>, Bryce says...
>
>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

While ORA-3113 can be a symptom of network problems, my guess is that it is being caused by a fault in the server. Run the procedure and check for newly-created trace files on the server. The trace file will probably contain a stack showing the error. Contact Oracle support and provide them the file.

                              Rick


-- 
                                Rick Wessman
                                Oracle Corporation
     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.