Click to See Complete Forum and Search --> : Accessing Oracle Stored procedure


syamala
March 14th, 2001, 02:11 PM
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.

Srikanth_hlp
March 14th, 2001, 04:43 PM
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