I create a form which use the web service. My output is come in xml form like..
I presume output=Response.
I want only element data like 0622, DOOR CABINET. Is it possible to remove the xml heading?? Please help..
Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
Use XQuery functions. You could start from here http://www.oracle.com/technetwork/articles/quinlan-xml-095823.html
It's really very good document. I am not able to register my schema. Please suggest how can i use this funtion DBMS_XMLSCHEMA.registerSchema for given below code and plz tell me if any simple way to convert xml output.
a. You not really have to use the WSDL for this processing. It cannot be used to generate stubs/interfaces, like in .NET or Java, in PL/SQL.
b. You also do not need to use SCHEMA
All you need to use is to start from "Understanding XQuery Functions and Expressions" section in the link.
The above is the faster / more efficient approach most of the time. For complex stuff you could also look at DBMS_XML* Packages in Packages and Types Reference documentation.
If search the internet you will find some examples and code for using the above.
Hint: Search with the package/function name and XML as keywords
which i displaying in text item. Now i want to show element value 0622, and DOOR CABINET and etc.
If i store this data in xml table then how can i show it because this data in xml form. To resolve i have to register the schema as per the document. I am not able to register the schema. Second If i use
select value(Person) asd
from test_xml_tbl i,
extract(i.object_value, '/NewDataSet/Table/PRIVATE_MARKA_BATCH_NO'))) person
where existsnode(i.object_value, '/NewDataSet/Table[@id="2006Sept1to30PA"]') = 1;
then return data in xml form so i am not able see it. any conversion from xml to character??