<div>
btw, because this is for a test case and library, I already have versions using out parameters. &nbsp;I can't use them for this.
</div>


btw, because this is for a test case and library, I already have versions using out parameters.  I can't use them for this.

<div>
<div class="content wysiwyg-content">
I've written a dab type oracle helper class using adp.net 10.0.2. &nbsp;I'm writing the test harness and documentation for it right now. &nbsp;I'm looking for an example of a pl/sql stored procedure to return a single value.<br />
for example in a text version I'm using &quot;select count(*) from regions&quot; and that works for<br />
result = &nbsp;cmd.ExecuteScalar.(OracleC<wbr />ommandType<wbr />.Text,MyTe<wbr />xt);<br />
How do I do this same thing in a pl/sql stored procedure? I want to use the function<br />
result = cmd.ExecuteScalar.(OracleC<wbr />ommandType<wbr />.Storedpro<wbr />cedure,MyS<wbr />ProcName);<wbr /><br />

</div>
</div>


I've written a dab type oracle helper class using adp.net 10.0.2.  I'm writing the test harness and documentation for it right now.  I'm looking for an example of a pl/sql stored procedure to return a single value.
for example in a text version I'm using "select count(*) from regions" and that works for
result =  cmd.ExecuteScalar.(OracleCommandType.Text,MyText);
How do I do this same thing in a pl/sql stored procedure? I want to use the function
result = cmd.ExecuteScalar.(OracleCommandType.Storedprocedure,MySProcName);


adp.net executescalar usage example request

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.