Execute Oracle Procedure in VBScript
Its been a long long day, and somehow I think i am exhausted looking for a solution.
I have an Oracle database, containing an indipendent stored procedure (not under any package, i dont have any packages defined yet) . This procedure contains 3 parameter, the first two beign type varchar2, direction in. The third being type reference cursor direction out.
I have to write a procedure in vbscript (file: poptransactions.vbs)
which will execute this stored procedure and should display the 15 results on a popup box.
Can some one please show me
1. how to execute an oracle stored procedure which returns a reference cursor under vbscript (how to specify a reference cursor as a parameter ?? - no clue :( )
2. And how to handle this cursor to use the records.