provider cannot derive parameter information

I'm rewriting my application to access an Oracle database but when I call:

ADODataModule.ADOStoredProc1.ProcedureName :=
'p_create_new_record';
ADODataModule.ADOStoredProc1.Parameters.Refresh;

I get the message:

provider cannot derive parameter information and setparameterinfo
has not been called

I'm using Delphi 7, Oracle 8 , and the Oracle ADO Provider. The Microsoft
provider works, up to the point I encounter BLOBs in the database.

Any ideas would be greatly appreciated.

Peter


.

Relevant Pages

  • Re: Oracle Provider Comparison
    ... I'm creating a web app that needs to provide some simple, ... access to an Oracle database using SELECT statements. ... curious about is which provider ... DataSet dsOracleOutputCursor = new DataSet; ...
    (microsoft.public.dotnet.framework.aspnet)
  • Oracle OleDb
    ... I have an asp.net application that connects to a oracle database with ... the microsoft OLE DB provider. ... is opened with a admin account. ... Provider, ...
    (microsoft.public.dotnet.general)
  • Re: Microsoft Oracle Data Provider
    ... to access an Oracle database. ... noticed some articles regarding support or distributed transactions. ... This appears to be specific to an earlier version of the provider ...
    (microsoft.public.dotnet.framework.adonet)
  • Oracle Provider Comparison
    ... I'm creating a web app that needs to provide some simple, ... access to an Oracle database using SELECT statements. ... curious about is which provider ... able to get a paramaterized SqlDataSource to work with the ODP.NET ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Reading an adVarNumeric field from an Oracle database
    ... What provider are you using, is it MSDAORA? ... This posting is provided "AS IS" with no warranties, ... > Hi, I'm trying to read a adVarNumeric field from an Oracle database, but ...
    (microsoft.public.data.oledb)