- This topic has 0 replies, 1 voice, and was last updated 9 years ago by
.
-
Posts
-
-
Hi,
Sorry to distrubt u. I could not find the solution for it. Could you pleae kindly help me to solve this issue?
I have package to retrieve data from table. When i call the package in the request-respond send port , I am getting only one row as response. I should get 5 lines(for this sender). could you tell me what i should do to get all the records? Do I need to do any set up in schema that generated by “add generate item” or in the procedure in oreder to receive all the data?
Package is:
CREATE OR REPLACE PACKAGE SALES_REPORT_LENOVO_867 ASPROCEDURE P_SALES_REPORT(iSender in varchar2,oISSUE_CODE out varchar2, oISSUE_DESC out varchar2);
END SALES_REPORT_LENOVO_867;
CREATE OR REPLACE PACKAGE BODY SALES_REPORT_LENOVO_867 AS
PROCEDURE P_SALES_REPORT(iSender in varchar2,oISSUE_CODE out varchar2, oISSUE_DESC out varchar2)
IS
BEGIN
SELECT ISSUE_ID, CODE_DESC INTO oISSUE_CODE, oISSUE_DESC
FROM SALES_ISSUE_IN
WHERE SENDER = iSender;
EXCEPTION
WHEN OTHERS THEN
NULL;
END P_SALES_REPORT;
END SALES_REPORT_LENOVO_867;
/
It should return 5 records. I am getting only one record as response. Please help me to fix this issue.
Thank you,
Siva
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.