| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
