Heterogeneous Services help needed

[kutz13]

We're using HS from an Oracle 10g instance to connect to a SQL server 2000 instance. We can use a 'select' query to find single values from a result set, but how do you return entire multiple rows? The syntax we use for single values is:

DECLARE
   c      INTEGER;
   nr     INTEGER;
   val1   VARCHAR2 (100);
BEGIN
   c := DBMS_HS_PASSTHROUGH.open_cursor@sqlserver;
   DBMS_HS_PASSTHROUGH.parse@sqlserver (c, 'select * from table1');

   LOOP
      nr := DBMS_HS_PASSTHROUGH.fetch_row@sqlserver (c);
      EXIT WHEN nr = 0;
      DBMS_HS_PASSTHROUGH.get_value@sqlserver (c, 1, val1);
      DBMS_OUTPUT.put_line (val1);
   END LOOP;

   DBMS_HS_PASSTHROUGH.close_cursor@sqlserver (c);
END;

Any help appreciated.