4 Replies Latest reply: Sep 27, 2013 5:05 AM by odie_63 RSS

    XMLType Column Update

    INRi

      I have table like-

      CREATE TABLE T_TEST(NAME VARCHAR2(100),INFO XMLType);

       

      I am trying to update the INFO column using below update statement-

       

      UPDATE T_TEST

      SET INFO=XMLTYPE(BFILENAME('ORADIR','test.xml'),nls_charset_id('AL32UTF8'))

      WHERE NAME='SAM'

      /

       

      If i am updating in Release 11.2.0.1.0- it successfully updated.

       

      If i am updating in Release 11.2.0.3.0 it giving error-

       

      UPDATE T_TEST

      *

      ERROR at line 1:

      ORA-03113: end-of-file on communication channel

      Process ID: 3716

      Session ID: 328 Serial number: 297

       

      Thanks,