Hi,
I have problem in accessing stored procedure with IN parameters.Please let me know hot to pass parameters to procedure which is created in Oracle from VB using command object.
Thanks in advance.
Printable View
Hi,
I have problem in accessing stored procedure with IN parameters.Please let me know hot to pass parameters to procedure which is created in Oracle from VB using command object.
Thanks in advance.
Using createparameter method create explicitly the parameters with command object that corresponds to the parameters with stored procedure and set the value property for the parameters which are supposed to be IN.
Or Else use refresh method to get the parameters autodefined from the procedure and then set the value property
- Srikanth