Skip to Content
0
Former Member
Mar 05, 2009 at 07:32 AM

Reg:Package in Oracle JDBC

18 Views

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" ?>

- 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" .