Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > get out parameter from oracle stored procedure

Reply
Thread Tools

get out parameter from oracle stored procedure

 
 
raymond chiu
Guest
Posts: n/a
 
      01-16-2006
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


 
Reply With Quote
 
 
 
 
Tushar Agarwal
Guest
Posts: n/a
 
      01-21-2006
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Call SQL Server 2000 Stored Procedure with in and out parameter Sanjeev Java 1 12-12-2007 11:18 AM
'Procedure or function <stored procedure name> has too many arguments specified',,,ARGH! Mike P ASP .Net 0 06-19-2006 01:19 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
Cannot get OUTPUT parameter after running Sql stored procedure MS ASP .Net 5 01-31-2005 08:09 AM
Calling Oracle stored procedure using c# Sudhish K V ASP .Net 1 11-11-2003 07:04 PM



Advertisments