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)
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?
Desperate in Toledo
You're probably looking for the Enterprise Libary forum. This is the CodePlex site discussion forum.
Find it here: http://www.codeplex.com/entlib.