Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle's XSQL and the greater than sign
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 `>' or `>' 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 > 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 BoyerReceived on Mon Jul 08 2002 - 13:36:06 CDT