11-30-2011, 09:09 AM
We have a procedure call with 134 variables in Oracle. data type for most of them is varchar2 and when i define it in VBscript according to the ADO data type, it throws exception. I tried several data types in ADO but no success. Any help is appriciated.
I used the recordset for this the procesure completes without error but then output is not displayed. Procedure call send the input variables and once completed i get three output value, a unique number, a code for sucessfull comletion and a array. I just need to get the unique number and use it in further validation.
I used the recordset for this the procesure completes without error but then output is not displayed. Procedure call send the input variables and once completed i get three output value, a unique number, a code for sucessfull comletion and a array. I just need to get the unique number and use it in further validation.