Hello All,

Can any one please let me know how to retrieve adodataset from oracle stored procedure. I need to use TadoQuery component.

Here is my simple SP with package

CREATE OR REPLACE PACKAGE RefCur_pkg
AS
TYPE testcur IS REF CURSOR;
PROCEDURE test_sp(name in varchar, o_Cursor OUT testcur);
END RefCur_pkg;


CREATE OR REPLACE PACKAGE BODY RefCur_pkg
AS
PROCEDURE test_sp(name in varchar, o_Cursor OUT testcur)
IS
BEGIN
OPEN o_Cursor FOR
SELECT * FROM categories;
END test_sp;
END RefCur_pkg;



In delphi5 my code is like ...


With (ADOQuery2) Do
Begin
Close;
Sql.Clear;
Sql.Text := 'call refcur_pkg.employeesearch(?)';
Parameters.CreateParameter'test1',ftstring,pdInput ,10,null);
Parameters.CreateParameter('cur',ftCursor,pdOutPut ,2000,null);
ExecSql;
End;

I'm getting an error like 'parameter object is improperly defined. inconsistent or incomplete information provided'.

Can anyone please solve my problem.... Please.!