TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Sudipta Saha
NA
85
13.5k
what is the C# code to read types.cursortypes in procedure
Jan 2 2018 1:55 AM
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;
And my C# code is
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??
Reply
Answers (
7
)
Dynamic User Control
save image into folder and database its path from web servic