Home » Developer & Programmer » JDeveloper, Java & XML » XML Parser for PL/SQL problem -parameter passes 'foobar'
XML Parser for PL/SQL problem -parameter passes 'foobar' [message #90977] Wed, 23 January 2002 13:11 Go to next message
Ed
Messages: 24
Registered: November 1999
Junior Member
Hi,
I have the following sp on oracle 8i using the XML Parser for PL/SQL

Why doesnt the line
searchName:=xmldom.getNodeValue(xmldom.item(XML_NodeList,0));

return me the node value "foobar"?

TIA

Note Input Param listed in subject (value has been escaped).
Stored Proc is below:

PROCEDURE GetEntitiesNew(SearchParams IN VARCHAR2)
IS
searchType VARCHAR2(100);
searchName PROPSD_ENTITY.NAME%TYPE;
queryContext DBMS_XMLQuery.ctxType;

XML_Parser xmlparser.parser;
XML_Doc xmldom.DOMDocument;
XML_NodeList xmldom.DOMNodeList;

BEGIN

XML_Parser :=xmlparser.newparser;

xmlparser.parsebuffer(XML_Parser,SearchParams);
XML_Doc:=xmlparser.getDocument(XML_Parser);
XML_NodeList:=xmldom.getElementsByTagName(XML_Doc,'*');

searchName:=xmldom.getNodeValue(xmldom.item(XML_NodeList,0));

dbms_output.put_line('here it is ' || searchName);
END GetEntitiesNew;
Re: XML Parser for PL/SQL problem -parameter passes 'foobar' [message #90983 is a reply to message #90977] Mon, 28 January 2002 17:28 Go to previous messageGo to next message
ashraf
Messages: 3
Registered: January 2002
Junior Member
I have problem in pl/sql , can you help me in that please .
thankyou very much .'

ashraf
Re: XML Parser for PL/SQL problem -parameter passes 'foobar' [message #91159 is a reply to message #90983] Mon, 13 May 2002 00:58 Go to previous message
SK
Messages: 26
Registered: March 2001
Junior Member
test
Previous Topic: Re: loading javaclass into database
Next Topic: Re: Urgent: Please help to automate password within batch files.
Goto Forum:
  


Current Time: Fri Mar 29 04:17:26 CDT 2024