Home » Developer & Programmer » JDeveloper, Java & XML » retriving XML tags from response xml using pl/sql (ORACLE 9i)
retriving XML tags from response xml using pl/sql [message #421105] Fri, 04 September 2009 04:46 Go to next message
rammohangowd
Messages: 2
Registered: September 2009
Location: India
Junior Member
I am trying to get the node list length from response xml. but it is giving error like..n1 is used but not declared. how can i extract namespace xml tags in pl/sql..
below is the code snippet which am trying to use for to get the length....

vdomnodelist := xslprocessor.selectNodes(xmldom.makeNode(vdoc),'/env:Envelope/env:Body/n1:addressMatchReturn');

htp.p('<br>node list length = '||xmldom.getlength(vdomnodelist));
Re: retriving XML tags from response xml using pl/sql [message #421110 is a reply to message #421105] Fri, 04 September 2009 05:25 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
When you get an error, don't post that you get an error "like", post the EXACT error. Because with the exact error, people (including you) can look up the error. For example, here the error might be LPX-00307:

oracle ~ $ oerr LPX 00307
00307, 00000, "namespace prefix ~S used but not declared"
// *Cause:  Namespace prefix is used but not declared.
// *Action:  Either declare the namespace or don't use this namespace prefix.
Re: retriving XML tags from response xml using pl/sql [message #421111 is a reply to message #421110] Fri, 04 September 2009 05:32 Go to previous messageGo to next message
rammohangowd
Messages: 2
Registered: September 2009
Location: India
Junior Member
sorry...this is the error which iam geting.

ORA-20100: Error occurred while processing: Namespace prefix 'n1' used but not declared.
ORA-06512: at "SYS.XSLPROCESSOR", line 22
ORA-06512: at "SYS.XSLPROCESSOR", line 502
Re: retriving XML tags from response xml using pl/sql [message #421114 is a reply to message #421111] Fri, 04 September 2009 05:40 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
OK. Errors in the >20000 range are user defined errors. That means the error handling is done by custom routines that the person that wrote the program did.

You will need to ask the person who wrote the program what the error means.

It MIGHT be that that person just did some stupid "when others" error handling that doesn't really do anything beside hide the real error. If that is the case, and the error that is hidden by it is really the LPX-00307 error, then the cause woudl be that the n1 name space is not defined in the DTD of the XML.
Re: retriving XML tags from response xml using pl/sql [message #421120 is a reply to message #421105] Fri, 04 September 2009 06:31 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There are many examples that show how to get data from xml in "JDeveloper, Java & XML" forum.

Post an example of what xml data you have and what you want.

Regards
Michel
Previous Topic: Newbie! Please Help - XML to Relational Table (I have searched)
Next Topic: Java stored procedure error compilation
Goto Forum:
  


Current Time: Thu Nov 21 11:18:37 CST 2024