ORA-19213
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 16 Jun 2020 13:01:40 -0400
Message-ID: <5d11edc8-bea0-48bc-2d4b-fe44a9c5b74a_at_gmail.com>
For some reason, Oracle is parsing XML in a VARCHAR2 field as an XML. On query from the table, I am getting ORA-19213 and LPX-00242 invalid use of ampersand. I am just trying to spool the data into a file, essentially doing select * from problem_table. Is there any way to turn off XML processing in the VARCHAR2 fields which are not declared as XMLTYPE?
Date: Tue, 16 Jun 2020 13:01:40 -0400
Message-ID: <5d11edc8-bea0-48bc-2d4b-fe44a9c5b74a_at_gmail.com>
For some reason, Oracle is parsing XML in a VARCHAR2 field as an XML. On query from the table, I am getting ORA-19213 and LPX-00242 invalid use of ampersand. I am just trying to spool the data into a file, essentially doing select * from problem_table. Is there any way to turn off XML processing in the VARCHAR2 fields which are not declared as XMLTYPE?
BTW, SQLcl 19.4 doesn't fail. It only retrieves 36000 out of 167507 and says that it has completed the task.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 16 2020 - 19:01:40 CEST