PC Review


Reply
Thread Tools Rate Thread

Accessing arrays returned by Oracle Stored Procedures using Oracle

 
 
=?Utf-8?B?S3VtYXIuQS5QLlA=?=
Guest
Posts: n/a
 
      18th Nov 2007
Hi All,
We are working on a web application being developed in Visual Studio 2005
with
oracle 9i database. One of our oracle stored procedure returns table objects.
While executing this stored procedure using OracleCommand
(System.Data.OracleClient)
object, we are having difficulty in adding an output parameter corresponding
to
this, to the OracleCommand object. Appreciate any solution for the same.

Please find below the code snippet of the stored procedure:

CREATE OR REPLACE PACKAGE Investment_Component AS
TYPE NumArray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
...
PROCEDURE CTE_INVEST_BALANCE_STATUS
(cur_dt_in IN DATE, -- current system business date
ccy_in IN VARCHAR2, -- currency code selection
lob_in IN VARCHAR2, -- Line of business code selection
t_date_cur IN OUT t_cursor,
ArraySize IN INTEGER,
BalAmtArr OUT NumArray,
InvAmtArr OUT NumArray,
DiffAmtArr OUT NumArray,
err_msg_inout IN OUT VARCHAR2);
END Investment_Component;

--
Kumar.A.P.P
Software Engineer, Infosys Technologies Limited.
http://techaid.wordpress.com/
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle Stored procedures =?Utf-8?B?c3BhcnR5MTAyMg==?= Microsoft Access VBA Modules 2 1st Jul 2005 05:51 PM
Accessing Oracle 9i Stored Procedures Using ADO.NET Oriol Tomās Microsoft ADO .NET 3 5th Nov 2004 08:48 PM
Calling stored Oracle procedures =?Utf-8?B?Smlu?= Microsoft Access VBA Modules 1 23rd Oct 2004 05:34 PM
Oracle Stored Procedures =?Utf-8?B?SmltIEhlYXZleQ==?= Microsoft ADO .NET 1 2nd Aug 2004 02:03 PM
Call Oracle Stored Procedures Raymond Chiu Microsoft Access External Data 1 31st Mar 2004 04:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:14 PM.