Home » Developer & Programmer » JDeveloper, Java & XML » oracle dbms_xmlquery.getxml error bind name identifier does not exist (Oracle 8i)
oracle dbms_xmlquery.getxml error bind name identifier does not exist [message #604532] Tue, 31 December 2013 15:17
rwinkler
Messages: 1
Registered: July 2008
Junior Member
Unfortunately I have to use xmlquery as this version of the application is on Oracle 8i I have implemented this successfully in the application however as an addition I needed to add a cursor to the query and modify the xsl to accept the results of that query and I cannot get away from this error the following is the cursor:

CURSOR (SELECT sum(jsi.qty_issued) as qty_issued,m.item_no as item_no,
m.UD_REF as ud_ref
FROM
stlm_job_stkitem jsi,
im_item_master m
WHERE jsi.job_id = 694754
AND jsi.site_id_no = 1
AND m.item_no = jsi.item_no
AND m.entity_all = jsi.item_entity and m.ud_ref is not null
group by jsi.qty_issued,m.item_no,m.ud_ref) each_item,

The xsl that receives the results is:
<xsl:choose>
<xsl:when test="EACH_ITEM/EACH_ITEM_ROW">
<xsl:for-each select='EACH_ITEM/EACH_ITEM_ROW'>
<ITEM SKU="{UD_REF}">
<xsl:value-of select="QTY_ISSUED"/>
</ITEM>
</xsl:for-each>
</xsl:when>
</xsl:choose>
There are 2 bind variables in the whole query but I hard coated some values in this cursor just to see the results in the xsl to no avail - your input is greatly appreciated.
Previous Topic: how to get last record value from a xml file
Next Topic: XML issue
Goto Forum:
  


Current Time: Fri Mar 29 05:41:26 CDT 2024