Oracle Error when Calling Oracle Stored Procedure via ADO

Problem Description:

When attempting to call an Oracle stored procedure from my Delphi application using the Microsoft Oracle OLEDB driver I receive the following Oracle error message: ORA-01036: illegal variable name/number. The code for the stored procedure is as follows:

create or replace package testpack as
type MyCursor is ref cursor;
procedure testproc(Ref_Cur_1 out MyCursor);
end;�

create or replace procedure testproc (Ref_Cur_1 in out cursor)
as
begin
open Ref_Cur_1 for
select * from customer;
end;

Problem Resolution:

You may be tempted to think that you should declare the cursor as an output parameter in your Delphi application. However for this simple stored procedure, this is not necessary with the TADOStoredProc, and�if you�try you will receive this error message.�All you need to do is hook up the connection property and set the procedure name property and a result set will be returned.