Response 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

Response issue

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

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Ask XML questions here] >> BizTalkers >> Response issue

Page: [1]

Message

<< Older Topic Newer Topic >>

Response 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

Post #: 1

RE: Response issue - 30 January 2008

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Are you using a map on the response?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to Siva)

Post #: 2

RE: Response issue - 30 January 2008

Siva

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

No, not at this moment. I am just trying to out put whatever comes as response, for testing purpose. I will use the map later on if i get all records in the response.
How can i trieve multiple records from oracle DB using oracle package/procedure and oracle adapter?
Thank you,
Siva

(in reply to Pieter)

Post #: 3