Database Software

Hi All

Im getting the ORA-01706 when i run the following SQL statement on a table containing XMLTYPE field:

select

           b.recid,

           bx.*

    from t24.F_OFS_REQUEST_DETAIL b

         cross apply xmltable('/row'

                       passing b.xmlrecord

                       columns transaction_ref  varchar2(30) path 'c4'

                             , user_name         varchar2(30) path 'c5'

                             , co_code            varchar2(30) path 'c6'

                            , status            varchar2(30) path 'c10'

                            , dateTimeRecd            varchar2(30) path 'c7'

                            , dateTimeProc           varchar2(30) path 'c9'

                            , msgOut       varchar2(4000) path 'c12[1]'

                            , msgIn       varchar2(4000) path 'c11[1]'

                       --     ,version       varchar2(30) path 'c2'

                         --   , msgOut varchar2(3000) path 'c12'

                  ) bx;

i tried to remove the fields one by one and i found that im getting the error for both "msgIn" and "msgOut". the string on those two nodes are very long and i dont know if this has to do with the error im getting or not.

im attaching to u also a file contianing the table script and sample of data in the table and the error im getting.

in the file u will see oracle version (12.1.0.2) and all information u may need.

any advice plz

BR