PL/SQL (MOSC)

MOSC Banner

ORA-31011: XML parsing failed LPX-00222: error received from SAX callback function

edited May 28, 2010 3:15AM in PL/SQL (MOSC) 2 commentsAnswered
Hi,
I am passing the xml contents as a param to a proc. I have exact same thing for 2 Tables. While it works for employee, it does not work for tab_BU. Except for the table name & column name.. everything else is exactly same , i still get those errors..
I upgraded from 10.2.0.1 to 10.2.0.4 as advised previously ans as said by matalink, that patchset 3 has XML bug fixes. Upgrade was smooth and my DB is up & fine.

Below is the working example....

Create table employee(
 EMPLOYEE_ID number,
 DEPARTMENT_ID number,
 salary number,
 Hire_date date,
 Job_id varchar2(20),
 Email varchar2(60),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center