Trying to use Nile Oracle DAAB in VB

[kzimme]

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...

 

[Guest]

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!
***************************