Re: C# and Oracle 8i - returns from stored procedures

"Bret" <bret.colburn_at_lmco.com> wrote in message news:1106848663.578907.176310_at_c13g2000cwb.googlegroups.com...
> I'm accessing a stored procedure that returns two parameters, the first
> is a string and the second is a cursor. I get the cursor data but not
> the string. Any ideas?

<snip>
> cmd.Parameters.Add("p_rc",OracleType.LongVarChar,50).Direction =
> ParameterDirection.Output;
> cmd.Parameters.Add("p_rowset",OracleType.Cursor).Direction =
> ParameterDirection.Output;
> OracleDataAdapter adapt = new OracleDataAdapter(cmd);
> adapt.Fill(myDataSet);
> // at this point I thought I'd have two tables in my dataset, the first
> containing only the string from the first parameter, the second
> containing the cursor data. I'm only getting one table and it contains
> the cursor data.

I don't think that I would expect a table for the string. I'd expect to use

String myvar := cmd.Parameters("p_rc").Value;

from memory.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com