Enterprise Library Data Access w\Oracle Number Parameter

Apr 19, 2007 at 7:01 PM
I am starting to use the Enterprise Library to access the packages and their procedures for an oracle database. I can use the update procedures in the packages successfully if the data type is all varchar, but I cannot figure out how to pass a number to a number parm in the Oracle procedure.

I am getting the error:
"Cannot bind type System.Int32 as Blob. SystemInvalidCastException"


Here is the vb.net code I'm using:
Dim dbcmbwrap9 As Oracle.OracleCommandWrapper = dbora.GetStoredProcCommandWrapper"BANKING.withdrawFromAcct")
dbcmbwrap9.AddInParameter("p_acno", OracleType.VarChar, "A100")
dbcmbwrap9.AddInParameter("p_amt", OracleType.Number, 100)
dbora.ExecuteNonQuery(dbcmbwrap9)

My oracle spec looks like:
Procedure withdrawFromAcct (p_acno IN accounts.acno%type,
p_amt In number);

I have written ADO.net code to use the above oracle spec and it works.

Does anyone know what OracleType I need to set to get the number to oracle or what other changes I need to make to have it work?

Thank you.
Desperate in Toledo
Sherry
Apr 19, 2007 at 10:07 PM
Hi Sherry,

You're probably looking for the Enterprise Libary forum. This is the CodePlex site discussion forum.

Find it here: http://www.codeplex.com/entlib.