Very Computer

Firstly sorry for the cross-post, Im not sure where this problem
belongs:

I am having problems calling an oracle stored function that returns a
recordset using Delphi 5 ADO components. Its driving me mad, and we're
working to a deadline which is approaching fast (of course). Any help
would be greatly appreciated.....

The Oracle function works correctly, returning a REFCURSOR type to SQL
*Plus.

The function takes a single VARCHAR2 parameter.
We are using Oracle 8.1.7 server and client, MDAC 2.6.1, Delphi 5 +
updates (including the ADO update). We need to use ADO as the system was
originally built using that & MS SQLServer.

When trying to use a TADOCommand to call the Oracle function component I
get the following error:

Merant Driver
ORA-06550: line 1, column 15:
PLS-00306: wrong number or types of arguments in call to
'GETPRIMARYKEYFIELDS'
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored

Oracle Driver
ORA-06550: line 1, column 7:
PLS-00221: 'GETPRIMARYKEYFIELDS' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Microsoft Driver
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'GETPRIMARYKEYFIELDS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

The Delphi code is as follows:
    adocmdRES.CommandText := 'GETPRIMARYKEYFIELDS';
    adocmdRES.CommandType := cmdStoredProc;
    with adocmdRES.Parameters.AddParameter do
    begin
      Name := 'PTABLENAME';
      DataType := ftString;
      Direction := pdInput;
      Value := 'ASSET';
    end;
    adocmdRES.Execute;

This reflects as closely as possible, an ASP code sample I found for
doing exactly this.

Ive tried all sorts and cant get this to work.

Please help.....

adocmdRES.CommandText := 'GETPRIMARYKEYFIELDS';
adocmdRES.CommandType := cmdStoredProc;
adocmdRES.Execute('ASSET');

or

adocmdRES.Execute(VarArrayOf(['ASSET']));