1 Reply Latest reply on Jul 8, 2019 2:47 PM by cormaco

    oracle XMLTABLE query   "end-of-file on communication channel ERROR"

    naveenmani912

      Hi ALL

       

      I have a query which uses XMLTABLE function to parse xml.

      But i am getting     "ORA-03113: end-of-file on communication channel whenever i am executing the query."

      Kindly, help with the error the following is the query

       

      DECLARE

         lvar    VARCHAR2 (32767);

         lnum    NUMBER;

      BEGIN

         SELECT MESSAGE_TEXT

           INTO lvar

           FROM internet_client_cics_trans_msg

          WHERE i_cics_txn_id = 28579 AND MESSAGE_TYPE = 'R';

       

       

          SELECT d.traceId

            INTO lnum

            FROM DUAL x,

                 XMLTABLE (

                    '/'

                    PASSING xml(lvar)

                    COLUMNS traceid VARCHAR2 (20)

                                  PATH '/authMethForUser/hdr/outHdr/traceId'

                            ) d;

      END;