locked
Please help in ORACLE SP and .NET Code to call the SP RRS feed

  • Question

  • User-327401599 posted

    Hi Friends,

    Please help me. This is my stored procedure

    create or replace
    PROCEDURE GET_SELECT1
    (
    p_recordset1 OUT Types.cursor_type) AS

    BEGIN
    OPEN p_recordset1 FOR
    SELECT * FROM TBL_SAMPLE WHERE Value= '72' and ceil(rownum/10)=1 ;

    END;

    How do i call this Stored procedure in C# code

    WIth out any oracle parameter i'm calling this SP. is this correct?

    dt = Orahelp.ExecuteNonQuery_SP("GET_SELECT1");
    return dt;

    Please do help me in fixing this issue.... 

    Monday, September 9, 2013 12:26 PM

Answers