Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BO and stored procedure

Status
Not open for further replies.

carmand

Programmer
Dec 8, 2003
3
FR
Urgent
I have a stored procedure which uses a oracle.sql.array type for the return value.
What's value indicating when i call this stored procedure in BusinessObjects ?

CREATE TYPE arrayReturn AS varray(1) OF number(1);

CREATE OR REPLACE PROCEDURE jpnsr_nm_net_volumeP( startDate in number, endDate in number, timeRate in varchar2, criterion in varchar2, valueOut OUT arrayReturn) AS
LANGUAGE JAVA
NAME 'com.bmc.pnsr.queries.network.Volume.selectP(long, long, java.lang.String, java.lang.String, oracle.sql.ARRAY[])';

Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top