XML Database (MOSC)

MOSC Banner

XMLTYPE.toObject causes a ORA-01722:invalid number error message in 10g

edited Jan 14, 2010 3:35AM in XML Database (MOSC) 4 commentsAnswered
 Hi,

I have a problem in Oracle 10g(10.2.0.2.3) while using the  XMLTYPE.toObject function ,but same thing is working fine in Oracle 9i.

declare
l_obj EDI855_T;
l_xml xmltype;

begin

    SELECT xmltype(xml)  INTO l_xml
      FROM xxxml_test_table
     WHERE process_nm = 'EDI855'
       AND status_cd = 'P'
       AND record_no = p_record_no;

    l_xml.toobject(l_obj, 'EDI855', 'PurchaseOrder');
end;

In the above program the l_xml.toobject is failing , I am getting the ora-01722:invalid number.

Highly appreciate if any one provide the solution.


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