Home » Developer & Programmer » JDeveloper, Java & XML » Casting In XML--Char to Number (oracle 10g)
Casting In XML--Char to Number [message #409760] Tue, 23 June 2009 22:25 Go to next message
pkumar_2008
Messages: 19
Registered: November 2008
Location: usa
Junior Member

Hi All,

I have an xmltype column in a table and amount value is stored as string .I am trying to get the aggregate amount but getting an error.


ORA-01722: invalid number
ORA-06512: at "SYS.XMLTYPE", line 168

SQl Query AS follows

SELECT
INSTRUCTIONTEMPLATEKEY,
TRANSACTIONTEMPLATEID,
EXTRACT(DETAILS,'/Trn/InstdAmt','xmlns="com.clear2pay.bph"').GETNUMBERVAL() AS INSTDCDTAMT
FROM
TRANSACTIONTEMPLATE



Actual values in amount Element in XML
2,860.00
435.00
5,931.00

...Please,help me...this is very very urgent...


Thanks In advance
Kumar
Re: Casting In XML--Char to Number [message #409761 is a reply to message #409760] Tue, 23 June 2009 22:44 Go to previous messageGo to next message
BlackSwan
Messages: 22728
Registered: January 2009
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: Casting In XML--Char to Number [message #409773 is a reply to message #409760] Tue, 23 June 2009 23:33 Go to previous message
Michel Cadot
Messages: 58959
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The only urgent thing for you to get a quick answer is to read OraFAQ Forum Guide and follow it.

Regards
Michel
Previous Topic: Loadjava in unix server
Next Topic: About a query
Goto Forum:
  


Current Time: Wed Sep 03 00:12:38 CDT 2014

Total time taken to generate the page: 0.19246 seconds