DevOps, CI/CD and Automation

Hello,

I'm using Delphi 7 and connecting via ADO 2.8 to a stored procedure in oracle via OLE DB 8.1.7. Provider: Oracle Provider for OLE DB.

I want to retrieve the parameters from the procedure but that isn't working. When i use the Microsoft provider: Microsoft OLE DB Provider for Oracle.
'Provider cannot derive parameter information and SetParameterInfo has not been called'

This is my Delphi Code:

FADOStoredProc := TADOStoredProc.Create(Self);
FADOStoredProc.Connection := ADOConnection1;
FADOStoredProc.LockType := ltReadOnly;
FADOStoredProc.CursorType := ctStatic;
FADOStoredProc.ProcedureName := 'TestProc';
FADOStoredProc.Prepared := True;
FADOStoredProc.Parameters.Refresh;

Why is this happening? What am i forgetting?

Thx for the input

Paul