datetime parameter against Oracle data source

I am going to google what is BLOB.

BLOB = Binary Large Object.

Which data type have you used for the parameters? Which data provider for Oracle are you using, OleDB or .NET? If it's OleDB please use the question mark ? as parameter instead of named parameters:

SELECT order_number 
FROM apps.oe_order_headers_all  
WHERE ordered_date >= ?
    AND ordered_date  < ?
    and rownum = 1

---

Olaf Helper

[ Blog] [ Xing] [ MVP]