RDO for Oracle stored functions

40041 - object collection - couldn't find item indicated by text

I get this error with trying to use following code to run oracle stored function with RDO through VB5. The error occurs when code is run by a user for oracle connection other than function owner. If function owner runs the code then it runs fine.

Does anyone know if :
#1. RDO has problems in running Oracle stored procs/funcs which are
owned by other user (ie running user qualified syntax such as user.object)

#2. I tried to create a public synonym for the object and run it and
same thing happens. Does RDO understand Oracle public synonym objects ?

If user has a local synonym for the object then it works so that's the work-around but not good because too many local synonyms will have to be managed for database with lots and lots of users.

Here is the code :

sSql = "{? = call carat.get_emp_segment(?)}"

Set qry = cn.CreateQuery("test", sSql)

qry.rdoParameters(0).Direction = rdParamOutput 'ERROR OCCURS HERE !!! qry.rdoParameters(0).Type = rdTypeVARCHAR

qry.rdoParameters(1).Direction = rdParamInput
qry.rdoParameters(1).Type = rdTypeNUMERIC
qry.rdoParameters(1).Value = 21920

qry.Execute Received on Fri Jan 02 1998 - 00:00:00 CET