Re: getting return value from oracle stored proc

You need to use execute scalar in order to retrieve the output parameter in this case. If you are attempting to use a reader, you have to add an output parameter of type refcursor. The only way to return data from oracle in a sequence is by using a refcursor. You should see the use of the cursor in the stored proc.

Dwayne

----- Original Message ----
From: Rinki Agarwal < vinki05%40yahoo.com">vinki05yahoo.com>
To: dba_gurus%40yahoogroups.com">dba_gurusyahoogroups.com; oracle_dba%40yahoogroups.com">oracle_dbayahoogroups.com; AspNetAnyQuestionIsOk%40yahoogroups.com">AspNetAnyQuestionIsOkyahoogroups.com
Sent: Tuesday, June 12, 2007 2:22:01 PM
Subject: [AspNetAnyQuestionIsOk] getting return value from oracle stored proc

Hello Everyone,
I can successfully insert and update the oracle database by calling a oracles stored proc from my .net code. This oracle stored proc is returning some value. I cannot see that value in my .net code
Below is my .net code
OracleParameter mbrid = new OracleParameter( "RET_MBRID" , OracleType.Number) ;
mbrid.Direction = ParameterDirection. Output;
OracleDataReader reader;
reader = command.ExecuteRead er();
while (reader.Read( ))
{
memberId = (string)reader[ "RET_MBRID" ];
}
I tested the oracle stored proc in sqlPlus and it is returning me value, but when i go to .net code, i cannot see the value of memberId. Am I doing something wrong here. Although my insert and update are working fine.
Insert and update statements are defined in the same stored proc.
I spent lot of time on this, but still cannot figure out why am I not getting the return value from oracle stored proc. I cannot even go inside the while(Reader. red()) statement
Any help will be grealty appreciated.

------------ --------- --------- ---
Shape Yahoo! in your own image. Join our Network Research Panel today!

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

.

Hashtables by their nature are not sortable. It has to do a I jump search to
find the value which means it needs flexibility to order them.

Just write some quick code to put it into a Sorted List.
http://www.learnasp.com/quickstart/howto/doc/list.aspx
is a good explanation of the collections. And how to iterate/copy from one
to another.

http://www.charlescarroll.com/chaz/site/5022/default.aspx
lists osme great subleties to the variosu collections.

On 6/12/07, ==>SamS<== < nsuresh_rasr%40yahoo.com">nsuresh_rasryahoo.com> wrote:
&gt;
> mycountries.Add(&quot;N",&quot;Norway");
> mycountries.Add(&quot;S",&quot;Sweden");
> mycountries.Add(&quot;F",&quot;France");
> mycountries.Add(&quot;I",&quot;Italy");
>
> I have a hashtable like this and i want to sort it over by value. Is it
> possible in vb.net??? Thanks,
> nsuresh_rasr
>
> [Non-text portions of this message have been removed]
>
>;
>

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

.

Guys/Gals,

I need to be able to better control the output of a precompiled website.

I am not happy with the way the default compile combines aspx pages into dll
files based on folders.

I would like to have complete flexibility on naming and merging.

If I wanted each individual aspx file to be compiled into a single dll with
the same name, is this possible?

It would sure help with version control.

Anyone have some good sources for documentation?

Thanks,

RickH

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

.

If I'm not mistaking you can use the commandline compiler for this + web application projects also seem to do exactly what you want.

Have a look at that here:

http://msdn2.microsoft.com/en-us/asp.net/aa336618.aspx

----- Original Message -----
From: Rick Holcomb
To: AspNetAnyQuestionIsOk%40yahoogroups.com">AspNetAnyQuestionIsOkyahoogroups.com
Sent: Thursday, June 14, 2007 4:09 AM
Subject: [AspNetAnyQuestionIsOk] Compiling and Publishing ASP.Net (2.0) websites.

Guys/Gals,

I need to be able to better control the output of a precompiled website.

I am not happy with the way the default compile combines aspx pages into dll
files based on folders.

I would like to have complete flexibility on naming and merging.

If I wanted each individual aspx file to be compiled into a single dll with
the same name, is this possible?

It would sure help with version control.

Anyone have some good sources for documentation?

Thanks,

RickH

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

.

If you want to do this, you need to move to a Web Application Project, which
is an add-in found in the VS SP1.

The standard Web Site project in 2.0 compiles to folder or single file
assemblies, the Web Application Project compiles to a single DLL.

This is a link to my blog entry that discusses it in more detail and has
relevant links.

http://www.vpsw.com/blogbaby/PermaLink,guid,27013c9f-ec59-4762-9569-462a9b6b6653.aspx

On 6/13/07, Rick Holcomb < rholcomb%40holc.biz">rholcombholc.biz> wrote:
&gt;
> Guys/Gals,
>
&gt; I need to be able to better control the output of a precompiled website.
>
>; I am not happy with the way the default compile combines aspx pages into
>; dll
> files based on folders.
>
>; I would like to have complete flexibility on naming and merging.
>
>; If I wanted each individual aspx file to be compiled into a single dll
> with
>; the same name, is this possible?
>
&gt; It would sure help with version control.
>
>; Anyone have some good sources for documentation?
>
> Thanks,
>
> RickH
&gt;
> [Non-text portions of this message have been removed]
>
>;
>

--
Dean Fiala
Very Practical Software, Inc
Now with Blogging...
http://www.vpsw.com/blogbaby
Microsoft MVP

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

.

Thanks to everyone who responded to my question.

Dean thanks for the blog link, very informative.

I will install SP1 and see what I can make of it.

RickH

_____

From: AspNetAnyQuestionIsOk%40yahoogroups.com">AspNetAnyQuestionIsOkyahoogroups.com
[mailto: AspNetAnyQuestionIsOk%40yahoogroups.com">AspNetAnyQuestionIsOkyahoogroups.com] On Behalf Of Dean Fiala
Sent: Thursday, June 14, 2007 9:59 AM
To: AspNetAnyQuestionIsOk%40yahoogroups.com">AspNetAnyQuestionIsOkyahoogroups.com
Subject: Re: [AspNetAnyQuestionIsOk] Compiling and Publishing ASP.Net (2.0)
websites.

If you want to do this, you need to move to a Web Application Project, which
is an add-in found in the VS SP1.

The standard Web Site project in 2.0 compiles to folder or single file
assemblies, the Web Application Project compiles to a single DLL.

This is a link to my blog entry that discusses it in more detail and has
relevant links.

http://www.vpsw.
&lt;http://www.vpsw.com/blogbaby/PermaLink,guid,27013c9f-ec59-4762-9569-462a9b6
b6653.aspx>
com/blogbaby/PermaLink,guid,27013c9f-ec59-4762-9569-462a9b6b6653.aspx

On 6/13/07, Rick Holcomb <rholcombholc. <mailto:rholcomb%40holc.biz&gt; biz>
wrote:
&gt;
> Guys/Gals,
>
&gt; I need to be able to better control the output of a precompiled website.
>
>; I am not happy with the way the default compile combines aspx pages into
>; dll
> files based on folders.
>
>; I would like to have complete flexibility on naming and merging.
>
>; If I wanted each individual aspx file to be compiled into a single dll
> with
>; the same name, is this possible?
>
&gt; It would sure help with version control.
>
>; Anyone have some good sources for documentation?
>
> Thanks,
>
> RickH
&gt;
> [Non-text portions of this message have been removed]
>
>;
>

--
Dean Fiala
Very Practical Software, Inc
Now with Blogging...
http://www.vpsw. <http://www.vpsw.com/blogbaby&gt; com/blogbaby
Microsoft MVP

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

.