Click here to Skip to main content
15,922,696 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# Progammer Forum for Beginners? Pin
OriginalGriff2-Jan-18 22:49
mveOriginalGriff2-Jan-18 22:49 
GeneralRe: C# Progammer Forum for Beginners? Pin
Dave Kreskowiak3-Jan-18 2:23
mveDave Kreskowiak3-Jan-18 2:23 
GeneralRe: C# Progammer Forum for Beginners? Pin
OriginalGriff3-Jan-18 2:33
mveOriginalGriff3-Jan-18 2:33 
GeneralRe: C# Progammer Forum for Beginners? Pin
Dave Kreskowiak3-Jan-18 4:18
mveDave Kreskowiak3-Jan-18 4:18 
GeneralRe: C# Progammer Forum for Beginners? Pin
OriginalGriff3-Jan-18 4:46
mveOriginalGriff3-Jan-18 4:46 
GeneralRe: C# Progammer Forum for Beginners? Pin
Dave Kreskowiak3-Jan-18 4:56
mveDave Kreskowiak3-Jan-18 4:56 
GeneralRe: C# Progammer Forum for Beginners? Pin
User987432-Jan-18 22:36
professionalUser987432-Jan-18 22:36 
GeneralRe: C# Progammer Forum for Beginners? Pin
Pete O'Hanlon2-Jan-18 22:40
mvePete O'Hanlon2-Jan-18 22:40 
GeneralRe: C# Progammer Forum for Beginners? Pin
User987432-Jan-18 23:09
professionalUser987432-Jan-18 23:09 
GeneralRe: C# Progammer Forum for Beginners? Pin
User987432-Jan-18 22:59
professionalUser987432-Jan-18 22:59 
GeneralRe: C# Progammer Forum for Beginners? Pin
OriginalGriff2-Jan-18 23:25
mveOriginalGriff2-Jan-18 23:25 
GeneralRe: C# Progammer Forum for Beginners? Pin
User987433-Jan-18 23:43
professionalUser987433-Jan-18 23:43 
GeneralRe: C# Progammer Forum for Beginners? Pin
Richard MacCutchan2-Jan-18 23:37
mveRichard MacCutchan2-Jan-18 23:37 
AnswerRe: C# Progammer Forum for Beginners? Pin
Pete O'Hanlon2-Jan-18 22:35
mvePete O'Hanlon2-Jan-18 22:35 
GeneralRe: C# Progammer Forum for Beginners? Pin
User987432-Jan-18 23:02
professionalUser987432-Jan-18 23:02 
GeneralRe: C# Progammer Forum for Beginners? Pin
Richard MacCutchan2-Jan-18 23:43
mveRichard MacCutchan2-Jan-18 23:43 
GeneralRe: C# Progammer Forum for Beginners? Pin
User987433-Jan-18 23:49
professionalUser987433-Jan-18 23:49 
AnswerRe: C# Progammer Forum for Beginners? Pin
Marc Clifton3-Jan-18 1:45
mvaMarc Clifton3-Jan-18 1:45 
GeneralRe: C# Progammer Forum for Beginners? Pin
User987433-Jan-18 23:39
professionalUser987433-Jan-18 23:39 
AnswerRe: C# Progammer Forum for Beginners? Pin
BillWoodruff4-Jan-18 4:29
professionalBillWoodruff4-Jan-18 4:29 
GeneralRe: C# Progammer Forum for Beginners? Pin
User987434-Jan-18 5:50
professionalUser987434-Jan-18 5:50 
GeneralRe: C# Progammer Forum for Beginners? Pin
BillWoodruff4-Jan-18 21:09
professionalBillWoodruff4-Jan-18 21:09 
QuestionQuestion On Using IProgress Pin
Kevin Marois2-Jan-18 12:51
professionalKevin Marois2-Jan-18 12:51 
AnswerRe: Question On Using IProgress Pin
Kenneth Haugland3-Jan-18 18:48
mvaKenneth Haugland3-Jan-18 18:48 
Questionwhat is the C# code to read TYPES.cursortype in procedure Pin
sudipta saha1-Jan-18 21:31
sudipta saha1-Jan-18 21:31 
I have a stored procedure like this


PROCEDURE PRC_ABCD_GETALL (resultset_out OUT TYPES.cursorType)  
AS  
BEGIN  
OPEN  
resultset_out FOR SELECT * FROM ABCD;  
END PRC_ABCD_GETALL; 


using (OracleConnection conn = new OracleConnection(cnn))
{
   conn.Open();
   OracleCommand cmd = new OracleCommand();
   cmd.Connection = conn;
   cmd.CommandText = "PRC_ABCD_GETALL";
   cmd.CommandType = CommandType.StoredProcedure;
   cmd.Parameters.Add("resultset_out", OracleType.Cursor, ParameterDirection.Output);
   OracleDataReader rdr = cmd.ExecuteReader();
   while (rdr.Read())
   {
      result.Add(Construct(rdr));
   }
}


but I'm getting error 'OracleDbType' does not contain a definition for 'Cursor' in
OracleType.Cursor. Any solution for this??

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.