MQSeries.net :: View topic - Problem while Querying the Oracle DB from Message Broker

udaya_isampalli · Posted: Fri Feb 09, 2007 5:39 am Post subject:

We are trying to fetch a result set from a Oracle Database table by issuing the following ESQL statement inside a message flow deployed to Message Broker V6.0

SET OutputLocalEnvironment.Variables.Values[] =
PASSTHRU ('SELECT Field1, Field2, Field3 FROM Schema.TableName WHERE
Field4 = ? AND Field5 = ?', Val_Field4, Val_Field5);

The database table has records that meet this SELECT query. But when the message flow is executed, many a times it returns no result set. There are no issues with the DSN or connectivity to Oracle from the message flow. This query returns the result set if the WHERE clause is removed. (However if this table is created in DB2 the above query always returns the result set).

Has anyone encountered this scenario, should the SELECT query be issued any differently for Oracle? Any pointers in this would be very helpful...