Receive port config issue?

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Receive port config issue?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Receive port config issue?

Page: [1]

Message

<< Older Topic Newer Topic >>

Receive port config issue? - 30 January 2008

Siva

Posts: 104
Score: 0
Joined: 20 September 2006
Status: offline

Hi,

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 SSIV.SALES_REPORT_LENOVO_867 AS
PROCEDURE P_SALES_REPORT(iSender in varchar2,oISSUE_CODE out varchar2, oISSUE_DESC out varchar2);
END SALES_REPORT_LENOVO_867;
CREATE OR REPLACE PACKAGE BODY SSIV.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