I got the output type issue resolved I had ParameterDirection.ReturnValue
for Output. Opps.
I have another issue now
see below stack trace for Oracle code
<Message>
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments
in call to 'GETMIDTIER' ORA-06550: line 1, column 7: PL/SQL: Statement
ignored
</Message>
<StackTrace>
at System.Data.OracleClient.OracleConnection.CheckError(OciHandle
errorHandle, Int32 rc) 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>
oracle package test code
TYPE
TYPE cur_MidtTier is REF CURSOR RETURN MidTier%RowType;
header
procedure GetMidTier(cur_getItems IN OUT cur_MidTier)
body
procedure GetMidTier(cur_getItems IN OUT cur_MidTier)
IS
BEGIN
open cu_getItems from select * from MidTier
end GetMidTier;
any clues would be great
You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced
DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
