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

Hi Alex,

You can try that using rdoQuery Objects directly from VB.

Thanks
Viky

Alexander Miroshnikov wrote:

> 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 Fri Jul 16 1999 - 09:18:53 CEST