Detecting column name and value from a xml

Advertisement

Dear all,
I need to create a procedure to get a xml file. The xml file may contain a table data or procedure parameter value. Off course it will also contain a flag if the data is of a procedure or table nnd then it's table or procedure name, column name(in case of table), and value. The procedure will receive the xml file and it does not know the column name in case of table or parameter name in case of procedure and then its value. i.e i have to parse the xml file without knowing the column name for table or parameter for procedure. Then i may populate data to my need. How can i do that? Please help me.
BR.
Tarik
Edited by: Tarik_kuet on Sep 23, 2008 2:32 PM
Edited by: Tarik_kuet on Sep 23, 2008 2:32 PM

Advertisement

You need to cast your data into an xmltype and look for the existence of nodes for tables, proceduresm etc
with xmldata
as
  (select  xmltype('<?xml version="1.0" encoding="UTF-8"?>
<Sample UniqueID="KWID_AP" >
     <Description>Sample Application</Description>
     <Table Name="SampleTable" />
     <Procedure Name="SampleProc" />
</Sample>') xml
from dual)
select * from xmldata
where existsnode(xml,'/Sample/Procedure')=1

October 11, 2015

Detecting column name and value from a xml

Dear all, I need to create a procedure to get a xml file. The xml file may contain a table data or procedure parameter value. Off course it will also contain a flag if the data is of a procedure or table nnd then it's table or procedure name, column

How to get the name and value of an attribute on a node/element that is not a child

Hello, Can someone shed some wisdom on how I can compare 2 xml nodes for differences. My main challenge is I need to use the attributes/values of 'ProductDescription' and 'Features' as 'key' to identify the same node in another doc with the same layo

How to find the column name and table name with a value

Hi All How to find the column name and table name with "Value". For Example i have value named "Srikkanth" This value will be stored in one table and in one column i we dont know the table how to find the table name and column name Any

How to put the column name and variable value in the alert message.

Dear, how can i put the column name and variable value in the alert message text. i want to display an alert which tell the user about the empty textboxes. that these textboxes must be filled. Regards: Muhammad Nadeem CHIMERA PVT. LTD. LAHORE [email 

Need help in extracting value from an xml tag.

Hi ALL, Good Morning to all, i have problem in fetching a value from a xml tag. I have created a xml schema based on the schema i have created a xmltype table and inserted a value to the table. When i am trying to fetch a value from a particular tag

How to specify pairs of variabel names and values in OdiInvoke

Hi, If you start the scenario from a web service, you are invoking the service OdiInvoke. When you look at the WSDL for this Web Service, you will notice that beyond the scenario name, version and the execution context, you can specify pairs of varia

Assigning a node value from an XML variable to a String type  in Weblogic Process Integrator

Hi, Is there any way to assign a node value from an XML variable to a String variable in Weblogic Process Integrator... Thanx. Narendra.Nerendra Are you talking about using Xpath on the XML document and assigning to a variable, it is unclear what you

Change column names when selecting from a collection

Anyone know how to change C001,C002...etc to readable column names when selecting from a collection? Aliases don't work! Paul PlattPaul, Edit the report attributes and change the column headings by selecting the "Custom" radio button first. Serg

I got an iTunes account years ago with an ID and password...them later got a mobile me and password...now I have an iPad and downloaded iCloud and I can't get my movies and tv shows on iPad because different account name and password from my mobile me.

I can't get my movies and tv shows on iPad now that I have added iCloud. The problem is that my iTunes account has different name and password from my mobile me account.  Can I change my iTunes account name and password so that they will transfer to

Send name and value of control to subvi

Hi all I am trying to send the names and values of controls to a subvi.  I know that I can extract the name and value of the control using a property node, but I was looking for a way to make is easy to use for the programmer. I am thinking of some k

Mapping node name and value

Hi, I have source strcture as ID Code Dept City My target structure is Name Value After mapping i need my target xml file to be <Object> <Name>ID</Name> <Value>001</Value> <Name>Code</Name> <Value>XYZ</Va

How to prevent middle names and titles from appearing in contacts

My iPhone is syncrhonised with MS Outlook, and I've used Outlook as my system of record for contacts for many years. I have hundreds of contacts in Outlook, many of which contain middle names and titles. The problem is that the iPhone displays every

Problem with getting the file name and type from OAMessageFileUploadBean

Hi Tapash, I am trying the code below to get the file name and mime type from OAMessageFileUploadBean, DataObject fileUploadData = (DataObject)pageContext.getNamedDataObject("Documents"); String uFileName = (String)fileUploadData.selectValue(nul

How can I hide the user name and password from the url address?

Good afternoon every body, I have a form running with Oracle9i Developer Suite Release 2 and when I run the form on the web it shows the user name and password of my data base. Can anyone of you please help me to hide the user name and password, if t

Edit env-entry values from web.xml in the WLS console.

Hi guys! Is it possible to define JNDI variables of type java.lang.String using WLS Console? ThanksI think this would require the use of a deployment plan, which you can learn about here: [http://e-docs.bea.com/wls/docs103/deployment/config.html] . T

Function module to get attribute and value from organisation model

Hi I need a function module to get the attribute and its corresponding values set on the sales org stucture.The export parameter will be the Sales Org Id. Please reply ASAP. Edited by: prem kumar on Apr 16, 2009 9:37 AMHi Prem, If it helps, we use FM

Charecteristic name and value

Hi gurus, I have ATNAM field maintained in a custom table and for this ATNAM I need to get corresponding ATWRT. please tell me how to fetch the data. regards satishHi Pete, thanks for the reply but ATNAM form CABN or CABNNEW I can get it but which fi

How to dynamically get default value from a table column

Hi all, Here's my problem: Our front end application sends insert and update queries to a pl/sql package. I've got a procedure that gets a PL/SQL table with all the column names an values, a table-name and a primary key name and value. That procedure

Invalid Column Name on db link from 11.2.0.2 Oracle to 11.2.0.2 Gateway

Hello, I am running the Oracle database 11.2.0.2 and using a database link accessing a sql server 2008 R1. The link is working fine, but a table has columns that are greater than 30 chars and Oracle db gateway cannot access this. Does anyone know of

Lookup Column name

Hi All I am new to OIM. Can anyone tell me what is the difference between Lookup Column Name and Column Name property of a lookup field while writing lookup query?Hi, Lets take an example here in the post given below. Re: Conditional forms Column Cap