JScript and Oracle Recordsets

date posted 9th January 2001 17:51

Hi all,

Trying to return a recordset from an Oracle stored procedure using JScript
and to cut a long story short it doesn't work.

I've ensured the correct ole db drivers are being used (records in oracle
stored procedures must use specific drivers) but the only examples i can
find are in vbscript and they don't work in the JScript context!!

An example of what i'm trying to achieve is:-

query.CommandText = "{call the_package.the_procedure({resultset 100,
out_variable})};
query.CommandType = adCmdText;

userRecSet = query.Execute();

All the above vars have been correctly defined but i'm trying to use the
vbscript syntax which isn't working. Anybody got an example of this in
JScript??

Best Regards

Gary.