XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Mapping XML to Oracle
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + How to add page number in to v... (2)
-> + XSL Grouping (7)
-> + Repeat images using FOR EACH l... (7)
-> + How to get File name (2)
-> + image and text on the same lin... (2)
-> + Create XSLT stylesheets for us... (2)
-> + Merge Multiple Files While Che... (2)
-> + xslt 3 level or multi level gr... (6)
-> + How to create xsl which will c... (2)
-> + xsl:variable and Result Tree F... (7)
-> - XSL-FO fo:table continued from... (1)
-> + XSLT Java issue (2)
-> + problem with hyperlink (4)
-> + substring-after function probl... (4)
-> + Xalan Processing (3)
-> + Memory utilization high with m... (2)
-> + check all parent node groups s... (2)
-> + CSV DOC to XML CONVERSION (11)
-> + XSLT: Ordered List (based on r... (4)
-> + XSLT Mapping - Issue (4)
-> + XSL following-sibling, how to ... (5)
-> + need xslt elements help (2)
-> + Dynamic generation of URL in X... (2)
-> + List Created from Section Navi... (2)
-> + xslt elements help (2)
-> + Map field if source is not nul... (3)
-> + XSLT group and sort whith gene... (4)
-> + Nested XML value (2)
-> + Specifying condition with coun... (4)
-> + xsl:function using found in er... (4)
-> + How to remove an unwanted spac... (2)
-> + Question about variable substi... (2)
-> + XSL for Comparing nodes and di... (4)
-> + External lookup list (8)
-> + XSL HTML output now needs to b... (2)
-> + Adding a new sub element to th... (4)
-> + How do I get rid of 'Tip' node... (9)
-> + Trying to dynamically create n... (2)
-> + Display XML link, using XSLT a... (9)
-> + calling templates based on ord... (2)
-> + How to add internal links usin... (4)
-> + How to call user defined java ... (3)
-> + XSLT and WebApps past and futu... (3)
-> + passing condition through java... (3)
-> + Apllying a template from withi... (4)
-> + Getting xsl element in javascr... (3)
-> + The document() function inside... (3)
-> + Footnote text move to para (2)
-> + XSL: multiple element come to ... (3)
-> + How to use following-sibling &... (2)
-> + How to use FOP 0.95 with Stylu... (4)
-> + Error during creating PDF from... (2)
-> + Help creating a comma delimite... (4)
-> + Selective Add using XSLT recur... (3)
-> + Help: convert without parent e... (2)
-> - Correct my substring function ... (1)
-> + Old xsl into reports (4)
-> + How to save xslt converted fil... (3)
-> + How to find non tagging text? (5)
-> + Help: Hex entity to Character... (6)
-> + EDI QUOTES MESSAGE NEED TO REP... (2)
-> + How to convert in multi level ... (4)
-> + Need some help with a styleshe... (3)
-> - Conditional Formattinf Formula... (1)
-> + Creating HTML Unordered LIsts.... (2)
-> + xslt params uknown number of i... (2)
-> + How to use fonts other than ba... (2)
-> - Converting existing HTML into ... (1)
-> + Help to tune up this XSLT (2)
-> + XSLT - is only converting the ... (2)
-> + XSLT Editor tab (4)
-> + Convert multiple files from XM... (2)
-> + how to use in select expressi... (2)
-> + Help needed in XSL transformat... (2)
-> + How to add a string with math ... (5)
-> + How to add a string with math ... (6)
-> - br element (1)
-> + Stylesheet directed terminatio... (2)
-> + Who can help me whit sum funct... (2)
-> + XSLT Works in Stylus Studio, n... (3)
-> - Filter by Attribute (1)
-> + Display x number of items whic... (6)
-> + MultiColumn Reporting (3)
-> + cant get namespace declaration... (3)
-> + Performance xsl:for each and n... (3)
-> + How to assign value to a XSLT ... (3)
-> + Select element value based on ... (2)
-> + Version 10 of Saxon? (8)
-> + How to get the value of a node... (5)
-> + Display Xpath using (4)
-> + XSLT to report (2)
-> + xslt help for a noobie (2)
-> + XSL-FO XML to PDF with XSLT (3)
-> + Using XSLT to transform XML to... (4)
-> + XSLT to sort a list alphabetic... (4)
-> + How to Get Colum Values based ... (2)
-> + non persisting predicate filte... (5)
-> + HTML to XSLT (2)
-> + extra carriage returns in "csv... (2)
-> + extra carriage returns in "csv... (3)
-- Previous [301-320] [321-340] [341-360] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
sue depaSubject: Mapping XML to Oracle
Author: sue depa
Date: 28 Jul 2005 06:08 PM
Hi All,

I need to map the xml file data to Oracle. Right now I am using the below PL/SQL to map the below xml element info.

XML element info:
<Carrier>
<OrganizationId>INTL</OrganizationId>
<OrganizationName>Integra Logistics LLC</OrganizationName>
</Carrier>

PL/SQL Code:

ELSIF LOWER(node_name)=LOWER('ORGANIZATIONID') THEN
m:=xmldom.getParentNode(m);
node_name:=xmldom.getNodeName(m);
dbms_output.put_line(' the parent node is: '||node_name);
m:=xmldom.getParentNode(m);
node_name:=xmldom.getNodeName(m);
dbms_output.put_line(' the parent node is: '||node_name);
IF LOWER(node_name)=LOWER('CARRIER') THEN
INSERT INTO CARRIER(recordnum,organizationid,code) VALUES
(rownumber,nodevalue,'shipment_status_214');

ELSIF LOWER(node_name)=LOWER('CarrierSCAC') THEN
INSERT INTO CARRIER(recordnum,scac_id,code) VALUES
(rownumber,nodevalue,'shipment_status_214');


ELSIF LOWER(node_name)=LOWER('ORGANIZATIONNAME') THEN
m:=xmldom.getParentNode(m);
node_name:=xmldom.getNodeName(m);
dbms_output.put_line(' the parent node is: '||node_name);
m:=xmldom.getParentNode(m);
node_name:=xmldom.getNodeName(m);
dbms_output.put_line(' the parent node is: '||node_name);
IF LOWER(node_name)=LOWER('CARRIER') THEN
INSERT INTO CARRIER(recordnum,organizationname,code) VALUES
(rownumber,nodevalue,'shipment_status_214');

ELSIF LOWER(node_name)=LOWER('CarrierSCAC') THEN
INSERT INTO CARRIER(recordnum,scac_name,code) VALUES
(rownumber,nodevalue,'shipment_status_214');
ELSE
dbms_output.put_line('unreferenced attribute ' || attrname || ' = ' || attrval);
Fnd_File.put_line(Fnd_File.LOG,'unreferenced attribute ' || attrname || ' = ' || attrval);
END IF;


And Now there is change in the XML Element above as follows:

<Carrier>
<OrganizationId type="SCAC">INTL</OrganizationId>
<OrganizationName>Integra Logistics LLC</OrganizationName>
</Carrier>


My program gives me error for this element saying Unreferenced element in attribute .... Please help me to map this info.

Thanks,
Sue
Postnext
Tony LavinioSubject: Mapping XML to Oracle
Author: Tony Lavinio
Date: 28 Jul 2005 08:22 PM
First, since this is really an Oracle issue and has little to do
with Stylus, you'd probably get a better answer on an Oracle support
forum.

But, you haven't shown all of the code (as indicated by the PL/SQL
program starting with ELSIF), and the error message you quoted,
"Unreferenced element in attribute" seems to be emitted from part of
the code that you _haven't_ posted. So it's hard to diagnose the
problem from what you've given.

Can you attach the whole procedure?

(And if you do post attachments, try using the checkbox above the
message text that says "Attach File" which will make it easier for us
to read.)
Postnext
sue depaSubject: Mapping XML to Oracle
Author: sue depa
Date: 29 Jul 2005 10:23 AM
Hi Tony,

Attached the Procedure.

Thanks,
sue.



UnknownPRP_DOMSAMPLE_214.PRC
Procedure
Postnext
Tony LavinioSubject: Mapping XML to Oracle
Author: Tony Lavinio
Date: 29 Jul 2005 11:28 AM
First, bear in mind that I haven't written PL/SQL within the past
few years, and haven't tested this, but it appears that the problem
is straight-forward to solve.

At line 78, right before the 'else', insert these lines

elsif lower(node_name)=lower('type') then
NULL;

this will cause it to skip the newly added 'type=' attribute
and hopefully will solve the problem.

Now, this is all assuming you don't care about the attribute
saying type="SCAC" in your input data.
Postnext
sue depaSubject: Mapping XML to Oracle
Author: sue depa
Date: 29 Jul 2005 01:03 PM
Tony,

Didn't work still same problem. Any other ideas...

Thanks,
Sue.
Posttop
Tony LavinioSubject: Mapping XML to Oracle
Author: Tony Lavinio
Date: 29 Jul 2005 04:10 PM
The only other idea I have is to ask this on an Oracle forum.
Sorry.

Although it doesn't have to do with Stylus Studio, we do try
to be helpful, but I don't have the resources to debug Oracle
problems.
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.