Topic
No replies
SystemAdmin
SystemAdmin
7754 Posts
ACCEPTED ANSWER

Pinned topic Unable to pass object from pl-sql to wps

‏2013-01-29T15:51:50Z |
Hi Team

I am trying to pass an object to a different system via WPS 6.2. I am using WPS 6.2 and Oracle 10g.

I want to pass an array of objects returned from a Pl Sql procedure as an output to WPS. However, am unable the object values are not being currently received by WPS. WPS calls this procedure (PlSql), which returns an array of objects. However, it reads the object values as '???'. We tried to write them in an XML

<FetchGENEVACustomerOutput>
<ResponseHeader>
<Status>0</Status>
<ErrorMessage>Accounts Details found for Customer with CRN=525Test_SP_TAM</ErrorMessage>
</ResponseHeader>
<GenevaCustomerDetails>
<AccountNumber>???</AccountNumber>
<ProfileID>???</ProfileID>
<BillingCurrency>???</BillingCurrency>
<InfoCurrency>???</InfoCurrency>
<City>???</City>
<State>???</State>
<BillTerm>???</BillTerm>
<PaymentDueDate>???</PaymentDueDate>

I hope I am posting the question in a comprehensive manner. Never worked with WPS before, it is a different team in our organization. Both of us are trying to solve the issue.

Thanks in anticipation