Trying to use Nile Oracle DAAB in VB

I am trying to use the Oracle DAAB found in the Nile application at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/manprooracperf.asp.

I am trying in VB 2003 to call an Oracle 9i stored procedure with parameters but I cannot seem to get past the compiler.

Oracle procedure:
CREATE OR REPLACE PROCEDURE insertNonQWP (repText IN VARCHAR2,repID IN NUMBER)
IS
BEGIN
UPDATE TESTNONQ SET TXTFIELD = repText WHERE TID = repID;
COMMIT;
END;

What am I doing wrong in my parameter assignment?
One of the examples in C# looks like:
OracleParameter[] ps = {new OracleParameter("CUSTOMERID",customerId), new OracleParameter("SESSIONID",sessionId), new OracleParameter("NETAMOUNT",netAmount), new OracleParameter("TAXAMOUNT",(Decimal.Multiply(netAmount, (Decimal)0.05))), new OracleParameter("TOTALAMOUNT",(Decimal.Multiply(netAmount, (Decimal)1.05))) };
OracleHelper.ExecuteNonQuery(m_connectionString, CommandType.StoredProcedure, "SP_PURCHASECARTFORSESSION", ps);

How do I do it in VB?
I tried:
Dim ps() As OracleParameter = {New OracleParameter("REPTEXT", "Junk"), New OracleParameter("REPID", 2)}
Dim rowAffected As Integer
rowAffected = OracleHelper.ExecuteNonQuery(connectString, CommandType.StoredProcedure, "insertTestNonQ", ps)
and I get an ?Overload resolution failed because no accessible ?ExecuteNonQuery? can be called with these arguments.?


**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

NoSpamMgbworld
Wed Mar 09 14:07:09 CST 2005

First, I would aim at downloading newer code
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlib.asp

Second, you have your array set up incorrectly:
Dim ps As OracleParameter()

I will have to go back to VB.NET to ensure the rest of the syntax is fine.
May not get to it immediately.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************


"Kiana Zimmerman" wrote:

> I am trying to use the Oracle DAAB found in the Nile application at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/manprooracperf.asp.
>
> I am trying in VB 2003 to call an Oracle 9i stored procedure with parameters but I cannot seem to get past the compiler.
>
> Oracle procedure:
> CREATE OR REPLACE PROCEDURE insertNonQWP (repText IN VARCHAR2,repID IN NUMBER)
> IS
> BEGIN
> UPDATE TESTNONQ SET TXTFIELD = repText WHERE TID = repID;
> COMMIT;
> END;
>
> What am I doing wrong in my parameter assignment?
> One of the examples in C# looks like:
> OracleParameter[] ps = {new OracleParameter("CUSTOMERID",customerId), new OracleParameter("SESSIONID",sessionId), new OracleParameter("NETAMOUNT",netAmount), new OracleParameter("TAXAMOUNT",(Decimal.Multiply(netAmount, (Decimal)0.05))), new OracleParameter("TOTALAMOUNT",(Decimal.Multiply(netAmount, (Decimal)1.05))) };
> OracleHelper.ExecuteNonQuery(m_connectionString, CommandType.StoredProcedure, "SP_PURCHASECARTFORSESSION", ps);
>
> How do I do it in VB?
> I tried:
> Dim ps() As OracleParameter = {New OracleParameter("REPTEXT", "Junk"), New OracleParameter("REPID", 2)}
> Dim rowAffected As Integer
> rowAffected = OracleHelper.ExecuteNonQuery(connectString, CommandType.StoredProcedure, "insertTestNonQ", ps)
> and I get an â??Overload resolution failed because no accessible â??ExecuteNonQueryâ?? can be called with these arguments.â??
>
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
>