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

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

    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()>'))

    Any feedback is welcome.


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

    Maybe this article will show you the direction you need...
    Hope that helped...
    Visit My Website :
    Tarry Singh

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

  3. #3
    Join Date
    Sep 2003
    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:
    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="" xml:lang="en">
    <my:start_date xmlns:xsi="">2003-09-20</my:start_date>
    <my:end_date xmlns:xsi="">2003-09-28</my:end_date>
    <my:event>conference A</my:event>

    If anyone has any idea, would you tell me?

    ps. I found that "" is very useful for its rich links!

    Originally posted by tarry
    You can,

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

Posting Permissions

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