Hey there,
I'd appreciate it if someone could offer some pointers.
I'm executing the following statement from my application against an
Oracle DB through an Oracle ODBC driver.
-----------------------------------------------------------------------------------------------------
SELECT *
FROM (OQ.omclassrel o
LEFT OUTER JOIN OQ.omrelationtype o2 ON o.RelType_oi=o2.rltypoi)
WHERE
(o.dmcroi <> 1000037465 OR o.dmcroi IS NULL )
AND
o2.rltypoi=?
-----------------------------------------------------------------------------------------------------
When I execute the above statement as shown I get no results (the
substituted bound parameter has a value of 1). However, if I swap the
order of the conditions following the 'WHERE' (while keeping the '?'),
then the query works as expected and returns some results.
Also, if I force the query to execute a 'hard-coded' statement by
placing the value of '1' in place of the '?', then the results is as
expected, regardless of the order of the criterion.
So, the only problem is when the inequality criteria is before the
criteria with the '?'.
I've verified that this is a problem against Oracle - not sure about
SQLServer, since when I generate my query against SQLServer, the order
comes out differently.
Can someone explain this?? Is there some rule that says inequalities
cannot come before parametrized variables??
Thanks
Mike Arsenault
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
