Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    14

    Unanswered: XSQL: can I use "bind-params" in "xsql:include-xml"?

    Hi,
    I want to know that I can use "bind-params" in "xsql:include-xml" tag
    like this,

    <xsql:include-xml bind-params="xxx">
    select SYS_XMLAGG(SYS_XMLGEN(PRO)).getClobVal() from PROS
    where Extract(event, '<PROS/PRO/name=xxx/text()>'))
    </xsql:include-xml>

    Any feedback is welcome.

    regards,

  2. #2
    Join Date
    Sep 2003
    Location
    Assen, Nederland
    Posts
    55
    You can,

    Maybe this article will show you the direction you need...

    http://radio.weblogs.com/0118231/2003/09/16.html
    Hope that helped...
    Visit My Website : http://www.oraflame.com
    _____________________________
    Tarry Singh

    OCP DBA 8i
    Currently: SQL Server DBA 7,2000
    Oracle, PHP Programmer

  3. #3
    Join Date
    Sep 2003
    Posts
    14
    Hi, tarry.

    Thank you so much for your reply.
    I checked the following site.

    Then, I found that maybe I can use the "bind-params" in the "xml:include-xml" as you say.

    I guess my problem was on the other point.
    Because I've tried to issue the following query from XSQL, but an error occurs even in the case at sql*plus command line like this,

    -----------------------------
    select SYS_XMLAGG(SYS_XMLGEN(EVENT)).getClobVal() from EVENTS
    where Extract(EVENT, TO_DATE('myfield/start_date/text()')) = '2003-09-13';

    Error Message:
    ORA-22950:
    cannot order objects with without map or order method.
    -----------------------------

    I used this query to create a table,

    -----------------------------
    create table EVENTS
    (event xmltype);
    -----------------------------

    and the following xml instance is I'd inserted to.

    -----------------------------
    <?xml version="1.0" encoding="UTF-8"?>
    <my:myfield xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2003-07-31T07:34:14" xml:lang="en">
    <my:start_date xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">2003-09-20</my:start_date>
    <my:end_date xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">2003-09-28</my:end_date>
    <my:event>conference A</my:event>
    ................
    </my:myfield>
    -----------------------------

    If anyone has any idea, would you tell me?

    ps. I found that "http://radio.weblogs.com" is very useful for its rich links!


    Originally posted by tarry
    You can,

    Maybe this article will show you the direction you need...

    http://radio.weblogs.com/0118231/2003/09/16.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •