(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,
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