Devart Forums

Hi,

I'm using dbExpress and I have created the following procedure in Oracle:

create or replace
procedure m_hcscurproc (p_cur out sys_refcursor)
IS
begin
open p_cur for
select orgid from organization;
end;

How do I write my SQL code to get the returned data?

Regards,

Bill

You can receive result set using TSQLStoredProc component. Please assign
SQLStoredProc1.StoredProcName:='m_hcscurproc';

Do I have to pass the cursor to the stored procedure as a parameter?

Regards,

Bill

No. You have to set SQLStoredProc1.StoredProcName and Connection.