Friday, 6 September 2013

Delphi: How to pass a table of records as a parameter to an Orcale Stored procedure

Delphi: How to pass a table of records as a parameter to an Orcale Stored
procedure

I have an oracle stored procedure that accepts a table of records as its
input parameter:
TYPE JREC is record
(
CUSTOMERID COMPANYS.COMPANYID%TYPE ,
JOBID JOBS.JOBID%TYPE,
-----
);
TYPE TJOBLIST IS TABLE OF JREC INDEX BY BINARY_INTEGER;
PROCEDURE UPDATEJOBS(JRECS IN TJOBLIST )
IS
BEGIN
FOR i IN JRECS .FIRST .. JRECS .LAST LOOP
-----PROCEDURE BODY---
Please let me know how can I call this procedure from Delphi. I am using
RAD Studio 2007
Thanks,
Pradeep

No comments:

Post a Comment