I have 2 queries that I need to join for a report.
My problem comes in that query 1 uses a field act_compldate defined as DATE in oracle table and query 2 uses act_scheddate defined as DATE in oracle table.
When I run query 1 the with a bind variable Report_Dt its TYPE defaults to DATE …
When I run query 2 with the bind variable Report_Dt its TYPE defaults to VARCHAR
When I join these queries the data type matching or rather mismatching ensues.
Any idea why the optimizer doesn’t see the bind variable the same way for each query?