MS SQL Server DTS - DTS query in Oracle seems to be dropping the where clause.....?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DTS query in Oracle seems to be dropping the where clause.....?

Steve

2006-03-31, 7:34 am

Hello

I have a DTS package that runs a transformation task against an Oracle
database using parameters in the source query.

The parameters seem to be substituted correctly at run time but elements of
the where clause are being dropped.

The query
select ID_number from test_tab
where (v_date between ? and ?)
and status is null

Returns data between the dates but ignores the status is null element.

I am using the Microsoft ODBC driver for Oracle.

Can anyone shed some light on why this is happing?

Cheers

Sponsored Links