OracleHelper.cs Data application block Question

  • Thread starter Thread starter Kevin Yu
  • Start date Start date
K

Kevin Yu

hi all

I have a store procedure that take a cursor as param that return a result
set like this:

procedure listprojects(io_cursor in out t_cursor)

where t_cursor is defined as

Type t_cursor is ref cursor;

now how do I make a call passing the cursor as param into the

ExecuteDataset() call?

thx


Kevin
 
The MS implementation is largely based on 8i. New features in 9i are not
fully supported, if at all. And, not all 8i features are supported
completely. You can use REF_CURSORS as output (really have to use them) and
have the MS implementation create result sets (DataTables), but you cannot
use a cursor as an input.

Download ODP.NET from http://otn.oracle.com. This is the Oracle .NET
software, which works much better with Oracle databases. Make sure you
download the correct version, as Oracle has a 10g version out there, as
well.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
 
Gregory

I have figured out the problem, but I will definitely check out the ODP.NET.

thx

Kevin
 
Back
Top