Send Null value to oracle stored procedure

[DannyTmoov2]

want to execute an oracle stored procedure sending parameters based on some vb.net form object values, which, if they are Nothing or "" (empty strings) then send the value Null to the procedure.

executing the procedure from oracle works fine using null for parameters, and executing the procedure from vb.net WITH valid values for parameters works fine, the problem is when i try to send a null value or exclude the parameter from VB i get the error:

An unhandled exception of type 'System.Exception' occurred in system.data.oracleclient.dll

Additional information: Parameter 'i_order_no': No size set for variable length data type: String.

That is using DBNull or DBNull.value as the parameter.

Any help much appreciated

 

[Dimandja]

Let's see your code.

__________________________________________
Try forum1391 for lively discussions

 

[Dimandja]

Also, have you tried:

param.Value = DBNull.Value

__________________________________________
Try forum1391 for lively discussions