Oracle functions and where clauses

Hello everybody,

I need to call an Oracle stored function and at the same time do a select on the result of the query, it works well except when I use a where clause. I am connecting to Oracle 8.1.7 through OLEDB using the Oracle provider for OLEDB distributed with this Oracle version.

Here is the query I am doing:

select * from {call MC.SEC.QryTermbases(?, ?) where ID = ?}

If I remove the where clause it works well but I need to use the where. I know that I could pass the parameter to the procedure instead of doing that in the select but there are places where I can not do that since the SQL query is generated dynamically. The code above is just a demo.

Thanks very much for your help,

José. Received on Mon Mar 17 2003 - 17:26:39 CET