Is there any Oracle guy who knows Delphi? I need help in calling oracle stored procedures by delphi application.My procedure is simple:
Code:
CREATE OR REPLACE PROCEDURE test_proc2(p_result OUT sys_refcursor) AS
BEGIN
  OPEN p_result FOR
    SELECT * FROM emp;
END;
I don't know how should I call this procedure within Delphi and return the cursor.I want to put the returned cursor into a grid.
-your help will be so appreciated.