Search results for query: *

Hi, I have a fairly large and complex XSL (around 1000 lines) that is used to convert XML into XHTML and display inside a webpage. I have a new situation where I need to add a header and footer to this stylesheet before I transform the XML with it. So, what I'm trying to do is write a...

Hi, I have a very simple xml structure that could have up 100 parts: <PARTS> <PART part_number="331077-05"/> <PART part_number="331030-05"/> <PART part_number="331552-05"/> </PARTS> I also have a pl/sql collection like this: TYPE myParts IS TABLE OF VARCHAR2(10); Is it possible to BULK...

Hi, I have a form and a textarea in which a user can input some XML to update a table. The column type in the database is XMLTYPE, so it must be a valid xml string going in or else an error is thrown. What's the best way to test that a string is valid XML? Thanks, Mike

I need to format currency such that: 1234.56 = 1,234.56 12345.6 = 12,345.60 123456 = 123,456 I'm using format-number(@price, '###,###.00'), but it leaves on .00. Is there a pattern to drop the decimal when it's .00? Thanks!

Hello, I'm trying to use XSL to the fullest by using templates instead of repeating my code. I have "PART" nodes that can be in the root document itself, or can be embedded in one or many levels deep in an "OPTION_CLASS" tag. Anytime I find at least one child PART node, I need to create a table...

Hi XSL Gurus, I need to flatten an XML hierarchy that can go many levels deep, to an XML doc that's only 1 level deep. In the flattened form, though, it must be able to reference what it's parent node used to be. Here's an example: <PACKAGE id = "1"> <OPTION_CLASS id = "2">...

I have an xml document that I need to read and insert records from. The nodes can be buried as many levels deep as they need to be, and it's giving me some problems. Here's my xml doc: <PACKAGE segment1 = "CFP" inventory_item_id = "213301"> <OPTION_CLASS segment1 = "CFP PAC"...

I need to write a view that joins part numbers in one table to a wom_id in another. The problem is the part numbers are crammed into a single column and delimited by "|". Is it possible to write a view on top of this join, that will normalize the result? Here is my query: Select w.wom_id...

Hi, I'm using Oracle's XMLTYPE to retrieve an XML doc, an XSL doc, and then transform the XML using the XSL. v_web_xml := get_web_xml('en-US', TRUE); v_web_xsl := get_web_xsl('MODELPAGE'); v_html := v_web_xml.transform(v_web_xsl); Here's a snippet from my xsl: <?xml...

Hello, I'm trying to use a math:max template that I found online, but I need it to work with attributes that may contain a word instead of a number. Here is the template: <xsl:template name="math:max"> <xsl:param name="nodes" select="/.." /> <xsl:choose> <xsl:when...

Hello, I'm trying to select an Oracle PTO/BOM as an xml document, and I need a little help. Here is my query: SELECT XMLELEMENT("PTO", XMLAGG( XMLELEMENT("OPTION_CLASS", XMLATTRIBUTES(msi.segment1 as "SEGMENT1", msi.inventory_item_id as "INV_ITEM_ID"), ( SELECT...

Hello, I'm working with a really old package that uses local or plain old pl/sql types defined in a package. Is it possible to access all of the types dynamically? Specifically, what I'm after, is the ability to say: TYPE t_info IS RECORD ( tax_type VARCHAR2(15), tax_rate_type...

Hello, I'm trying to add a toolbox to firefox right above my statusbar. I have the vbox, splitter, toolbox, toolbar, tabbox, etc. all in place, and it shows up correctly, but something is wrong in my XUL where I can't resize it vertically. <overlay> <vbox insertbefore="status-bar">...

Hi, I working with XMLELEMENT in my select to create an xmltype. I am wondering if it's possible to have the value of the column be the name of the xmlelement? Here's my query: SELECT XMLElement("result", XMLAGG(XMLElement("freight_term", XMLAttributes(site_use_code as...

I was formatting my 4GB compact flash card with Windows' built in format utility (you know, right click and format), when the computer froze and I had to reboot. Now the card only shows 498MB. If I try to reformat, it only has 498MB in the capacity drop down, so that doesn't seem to fix it. How...

I'm trying to highlight/select the text inside a table cell when the cell is clicked, but having problems. Here's what I thought would have worked. <td onclick="this.childNodes[0].select()"> Anyone know how this can be accomplished? Thanks!

Is it possible to separate the results of an XMLType.extract where many nodes match the XPATH? For example: DECLARE v_XML XMLTYPE := XMLTYPE('<root><text>one</text><text>two</text><text>three</text></root>'); BEGIN dbms_output.put_line(v_XML.extract('//text/text()').getstringval())...

Hi, Newbie here trying to write a script that runs when I click to open a folder, inside the "queryopen" event, which will delete any old emails that have the same subject as the new email that just came in. I have the folder sorted by date desc. Sub Queryopen(Source As Notesuiview, Continue...

I have the following function that appends a child node to a parent node and returns an XMLTYPE. FUNCTION append_element(parent XMLType, child XMLType) RETURN XMLTYPE DETERMINISTIC IS parent_document DBMS_XMLDOM.DOMDOCUMENT; parent_rootnode DBMS_XMLDOM.DOMNODE; child_document...

I have an xml doc and an xsl doc. Recently, the service that provides that xml has added an xmlns to the rootnode, and now my xsl doesn't work. Here is an example of what's happening: test.xml: <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type="text/xsl" href="test.xsl"?> <result>...