Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ADO Command.refresh fails to retrieve parameters for Oracle 8 stored procedure in different schema

Re: 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/28
Message-ID: <6aocjj$oqs$1@nnrp4.snfc21.pbi.net>#1/1 








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 Wed Jan 28 1998 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US