I got a managed Oracle class working but I am still unable to pull back a
ref cursor from oracle.
I have a test package built that resembles the code below
procedure GetMitTier(cur_getItems OUT cur_MidTier)
is
Begin
open cur_getTimes for select * from midTier
end
for the ParameterType I am using OracleType.Cursor which is (5)
the direction I am using is ParameterDirection.Output which is (2)
and I get the error message listed below. Any clues?
<DocumentRoot>
<Message>
parameter 'cur_MidTier': OracleType.Cursor parameters may only be
ParameterDirection.Output parameters.
</Message>
<StackTrace>
at System.Data.OracleClient.OracleParameterBinding.PrepareForBind
(OracleConnection connection, Int32& offset) at
System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle,
CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle&
rowidDescriptor, ArrayList& refCursorParameterOrdinals) at
System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle,
CommandBehavior behavior, ArrayList& refCursorParameterOrdinals) at
System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior
behavior) at System.Data.OracleClient.OracleCommand.ExecuteReader() at
ApolloDataRemoteHost.COracle.UseDataReader(OracleConnection Connection,
CommandType commandType, String commandText, OracleTransaction transaction,
OracleParameter[] OracleParams) in
c:\remoted\dataaccess\apollodataremotehost\coracle.cs:line 393
</StackTrace>
</DocumentRoot>
You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced
DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
