get out parameter from oracle stored procedure

Discussion in 'ASP .Net' started by raymond chiu, Jan 16, 2006.

  1. raymond chiu

    raymond chiu Guest

    Dear all,

    I have one stored procedure which has one (in out) parameter.
    How can I get the out parameter in .net development if I am using
    oracleselectcommand1.executenonquery() with assigning in parameters.

    Thansk,

    Raymond Chiu
    raymond chiu, Jan 16, 2006
    #1
    1. Advertising

  2. raymond chiu wrote:
    > Dear all,
    >
    > I have one stored procedure which has one (in out) parameter.
    > How can I get the out parameter in .net development if I am using
    > oracleselectcommand1.executenonquery() with assigning in parameters.
    >
    > Thansk,
    >
    > Raymond Chiu
    >
    >

    Hi Raymond,
    You should first add OleDbParameter object to your Command object and
    then acees it(after executing the command ) using Parameters ReturnValue.
    Tushar Agarwal, Jan 21, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sudhish K V

    Calling Oracle stored procedure using c#

    Sudhish K V, Nov 11, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    6,932
    David Browne
    Nov 11, 2003
  2. =?Utf-8?B?SmltIEhlYXZleQ==?=

    Oracle Calling A Stored Procedure

    =?Utf-8?B?SmltIEhlYXZleQ==?=, Nov 11, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    504
    Jeff Dillon
    Nov 11, 2004
  3. MS
    Replies:
    5
    Views:
    11,319
    Marc Scheuner [MVP ADSI]
    Jan 31, 2005
  4. Mike P
    Replies:
    0
    Views:
    3,283
    Mike P
    Jun 19, 2006
  5. Sanjeev
    Replies:
    1
    Views:
    395
    GArlington
    Dec 12, 2007
Loading...

Share This Page