ADO Command.refresh fails to retrieve parameters for Oracle 8 stored procedure in different schema

From: Chris Richardson <cer_at_sirius.com>
Date: 1998/01/26
Message-ID: <6aiebn$fff$1@nnrp3.snfc21.pbi.net>#1/1

Hi,

I am using ADO 1.5c with Microsoft's Oracle ODBC driver to access an Oracle 8 DB.
The stored procedures are in a PL/SQL package.

My code was successfully using Command.pameters.refresh to get a stored procedures parameters.
However, it only works if the procedure is defined in the logged in user's schema.
e.g. when user foo is logged in I was able to retrieve information about foo.package.procedureX using

    cmd.CommandText = "package.procedureX"
    cmd.CommandType = adCmdStoredProc
    cmd.parameters.refresh

When I try and access stored procedures in a different schema, refresh stops working - it retrieves
zero parameters, e.g

    cmd.CommandText= "barSchema.package.procedureX"
    cmd.CommandType = adCmdStoredProc
    cmd.parameters.refresh

    'At this point cmd.parameters.count equals 0

When command.execute is called I get an error message about invoking the stored procedure with the wrong number of parameters.

I have tried creating synonyms such as:

    create synonym <loggedinuser>.bsp for barSchema.package but that didn't make a difference.

Is this a known problem? Is there a workaround other than having everything in the same schema?
Thanks.

Chris Received on Mon Jan 26 1998 - 00:00:00 CST