Thx for the inputs, I've solved this, and here is the solution:
Since the boolean operators '<' and '>' also gave a problem, i replace these with
%3C (<) and %3E (>).
Then i wrap my date in a to_date('2007-04-13 12:16:40','YYYY-MM-DD HH24:MI:SS').
This gives a query looking like:
SELECT * FROM CATS_OWNER.V_CATS_CPH_WWW_SUBSCRIBE WHERE (FLT_TYPE in ('B','C','G','J','S') AND PUBLIC_ROLL_OFF = 0) AND SCHEDULE_TM %3E= to_date('2007-04-13 12:16:40','YYYY-MM-DD HH24:MI:SS') AND SCHEDULE_TM %3C= to_date('2007-04-13 14:16:40','YYYY-MM-DD HH24:MI:SS')
acw wrote:
When i try to fire this sql aganst Oracle
jdbc://SELECT%*%20FROM%20CATS_OWNER.V_CATS_CPH_WWW_SUBSCRIBE%20WHERE%20(FLT_TYPE%20in%20('B','C','G','J','S')%20AND%20PUBLIC_ROLL_OFF%20=%200)%20AND%20SCHEDULE_TM%20>=%20'2007-04-13%2012:16:40'%20AND%20SCHEDULE_TM%20<=%20'2007-04-13%2014:16:40'
i get an org.mule.umo.endpoint.MalformedEndpointException.
This sql works perfectly in sql+ and TOra.
The problem only comes when i add the last two conditions, SCHEDULE_TM >= '2007-04-13 12:16:40' AND SCHEDULE_TM <= '2007-04-13 14:16:40' ...SCHEDULE_TM is a Date field.
What's wrong with inserting dates this way?
