(wrong string) Á cursor from the Oracle stored function and accessing it through ODBC problem

From: Alexander Miroshnikov <alexander.miroshnikovNOSPAM_at_ntli.net>
Date: Mon, 14 Jun 1999 12:52:14 +0100
Message-ID: <7k2q5e$mau$1_at_nclient3-gui.server.ntli.net>



Dear Sirs,

I have got the following problem. Is it possible to return Á cursor from the Oracle stored function to the Visual Basic program and access it there through ODBC? I do not know whether the function result of the cursor type is supported by ODBC or not. The test function 'test_func' (see below) when it is called through ODBC raises exception.

create or replace package test_pack as
  type tcursor is ref cursor;
end;
/

create or replace function test_func return test_pack.tcursor as   result test_pack.tcursor;
begin
  open result for select * from user_objects;   return result;
end;
/

Yours sincerely,
Alex Received on Mon Jun 14 1999 - 13:52:14 CEST

Original text of this message