Is there any Oracle guy who knows Delphi? I need help in calling oracle stored procedures by delphi application.My procedure is simple:
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.Code:CREATE OR REPLACE PROCEDURE test_proc2(p_result OUT sys_refcursor) AS BEGIN OPEN p_result FOR SELECT * FROM emp; END;
-your help will be so appreciated.