call Oracle Function from VBScript using ADO
488790Sep 28 2007 — edited Oct 8 2007I was looking everywhere and found bits and pieces and never really fully working sample... does anybody have VBScript Sample for calling Oracle Function using ADO, please only VBScript, no VB, no C++, no ASP .... fully working VBScript.
I currently use this driver and would like to keep it, I can use OLE DB but it has to be Microsoft OLE DB for Oracle
Driver={Microsoft ODBC for Oracle}
here is my oracle function
FUNCTION TEST ( GIVEN_DAY DATE, INPUT_NAME VARCHAR2) RETURN NUMBER;
thanks a lot
jiri