OraFAQ Forum: JDeveloper, Java & XML » Casting In XML--Char to Number

Home » Developer & Programmer » JDeveloper, Java & XML » Casting In XML--Char to Number (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Casting In XML--Char to Number [message #409760]

Tue, 23 June 2009 22:25

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

Report message to a moderator

Re: Casting In XML--Char to Number [message #409761 is a reply to message #409760]

Tue, 23 June 2009 22:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Casting In XML--Char to Number [message #409773 is a reply to message #409760]

Tue, 23 June 2009 23:33

Michel Cadot
Messages: 68634
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

Report message to a moderator

Previous Topic:	Loadjava in unix server
Next Topic:	About a query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 01:49:54 CDT 2024