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
How to capture stored procedure query or print output in C#
Jan 16 2018 4:09 PM
I have a stored procedure like this
PROCEDURE
PRC_ABCD (resultset_out
out
TYPES.cursorType)
AS
SELECT
*
FROM
ABCD;
END
PRC_ABCD ;
And my C# code is like this
string
cnn =
"connectionstring"
;
OracleConnection conn =
new
OracleConnection(cnn);
conn.Open();
var cmd = adapter.CreateSpCommand(con,
"PRC_ABCD"
);
cmd = adapter.outField(cmd,
"resultset_out"
, OracleDbType.RefCursor);
using
(var reader = cmd.ExecuteReader())
{
while
(reader.Read())
{
yield
return
Total.FromDataReader(reader, vProductCount, vProductAreaCount, vMonitoredByCount, customerCount);
}
}
My question is how do I get to see the results of PRC_ABCD into console message or how do I get to print the query SELECT * FROM ABCD?Anybody have any info about this?
Reply
Answers (
3
)
Comparing an entered password with an asp.net Identity pwd
Grid View delete field got error