Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle's XSQL and the greater than sign

Oracle's XSQL and the greater than sign

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 8 Jul 2002 13:36:06 -0500
Message-ID: <uvg7q3w6i.fsf@grossprofit.com>


Oracle has a servlet engine which uses XML tags surrounding SQL to allow a client to post to a URL and recieve XML output.

A tag that executes a query looks like the following:

<xsql:query>

  select blah from table
</xsql:query>

I'm having trouble embedding a greater than sign in the SQL.

  <xsql:query bind-params="MERCHANDISE_ID">

    select min(t2.fiscal_wk) WEEK_PROMOTED     from planned_promos_tbl t1

            calendars t2
    where merchandise_id = ?
    and t1.start_dt > calendar_dt

  </xsql:set-session-param>

The bottom line of the sql has the `>' sign. When I execute this sql with either `>', as shown, or `&#62;' or `&gt;' I get the same exact message:

     <message>select  min(t2.fiscal_wk)           WEEK_PROMOTED
        from    planned_promos_tbl  t1
                calendars           t2
        where   merchandise_id = ?
        and     t1.start_dt &gt; calendar_dtORA-00933: SQL command not properly ended
    </message>

Even when I pass in the '>', it doesn't bomb thinking it has found an ending tag, but instead, converts it to its escaped version. The escaped version just doesn't get transformed into the correct SQL for the database.

Any ideas of other options or whats going on would be nice.

Thanks.

-- 
Galen Boyer
Received on Mon Jul 08 2002 - 13:36:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US