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

Well, I haven't tested it, but the 8.0.4 driver certainly exports it, (SQLProcedureColumns).

mark

On Wed, 28 Jan 1998 14:39:38 -0800, "Chris Richardson" <cer_at_sirius.com> wrote:

>
>mark tomlinson wrote in message
><34cf021e.65414471_at_newshost.us.oracle.com>...
>>Are you using the latest version of the 8.0 driver? (8.0.4.0.1)
>>
>
>
>It seems that the problem is with how ADO invokes SQLProcedureColumns.
>It calls this function passing schema.package.procedure as the name
>parameter.
>This does not work with the MS ODBC Oracle driver, i.e. SQLFetch returns
>SQL_NO_DATA.
>If you pass 'schema' as the value of the schema parameter and
>'package.procedure' as the value of the name parameter then things work just
>fine.
>
>BTW As far as I can tell SQLProcedureColumns does not work at all with
>Oracle's ODBC driver.
>
>Chris
>
>
>
>
Received on Thu Jan 29 1998 - 00:00:00 CST