I have a stored procedure on SQL server that can accept paramaters
and retrun more than one record/row

i need to execute such stored procdure using Oracle Transparent Getaway.



i found PL?SQL example to read from a table on Northwind on SQL server
----------------------------------------------------------------
DECLARE
val VARCHAR2(100);
c INTEGER;
nr INTEGER;
BEGIN
c := DBMS_HS_PASSTHROUGH.OPEN_CURSOR@GW_LINK;
DBMS_HS_PASSTHROUGH.PARSE@GW_LINK(c,'select ProductID, ProductName from Products where ProductID=1');
LOOP
nr := DBMS_HS_PASSTHROUGH.FETCH_ROW@GW_LINK(c);
EXIT WHEN nr = 0;
DBMS_HS_PASSTHROUGH.GET_VALUE@GW_LINK(c, 1, val);
DBMS_OUTPUT.PUT_LINE(val);
END LOOP;
DBMS_HS_PASSTHROUGH.CLOSE_CURSOR@GW_LINK(c);
END;
----------------------------------------------------------------------------


i don't need to do "select" i need to run the sql stored procdure and retun more than one record using cursor or so

please help