how to call store procedure using Oracle.DataAccess.Client

Question

i have a store 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

can anybody help me regarding this?

Sudipta Saha · Answer

thanks for reply sagar :) . let me go through those articles . thanks :)

Sagar Pandurang Kap · Answer

Hi Sudipta Refer following liks it might helps :- https://stackoverflow.com/questions/3940587/calling-oracle-stored-procedure-from-c http://www.c-sharpcorner.com/article/calling-oracle-stored-procedures-from-microsoft-net/ https://community.oracle.com/thread/3890831