Reg:Package in Oracle JDBC

[Former Member]

Hi...

I doing JDBC scenario . In the receiver side i am using JDBC adapter.

There i am using the package . In package it is having the stored procedure with out parameter as type table.

payser_pkg -- is the package name

rtgsneft -

---

is the stored procdure

The structure is like given below.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:Package_DB xmlns:ns0="http://axis.com/bank_statement">

- <Statement>

- <AXIS_PACKAGE action="EXECUTE">

<Table>"payser_pkg.rtgsneft"</Table>

<rec_rtgsneft_payments isOutput="true" type="VARCHAR" />

</AXIS_PACKAGE>

</Statement>

</ns0:Package_DB>

so i am calling like "payser_pkg.rtgsneft" .

[JoelTrinidade]

Please be a little more specific... cant get your question.

[Former Member]

Hi...

The below is the structure for the JDBC receiver.

Package name: payser_pkg

Stored Procedure: rtgsneft

The package is containing only one OUT parameter.The response from the package is the number of Table records.

In the below structure, rec_rtgsneft_payments is the OUT parameter.

For that can you tell what is the type of attribute i need to provide for type.?

The OUT parameter is a Table .

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:Package_DB xmlns:ns0="http://axis.com/bank_statement">

- <Statement>

- <AXIS_PACKAGE action="EXECUTE">

<Table>"payser_pkg.rtgsneft"</Table>

<rec_rtgsneft_payments isOutput="true" type="VARCHAR" />

</AXIS_PACKAGE>

</Statement>

</ns0:Package_DB>

Please help in this issue.

Thanks & Regards

Leela