Help in CURSOR VARIABLE

From: Isaac Chocron <itshak_at_hadassah.org.il>
Date: Sun, 07 Jun 1998 12:18:09 +0300
Message-ID: <357A5AD1.E2DFE362@hadassah.org.il>

We want to create a general procedure that receives any select statement, opens it and returns a cursor pointer( CURSOR VARIABLE). PACKAGE lib_cursor IS
  TYPE ty_gen_cursor IS REF CURSOR;
  PROCEDURE open_select

        ( io_select   IN VARCHAR2,
          o_cursor    IN OUT TY_GEN_CURSOR )  is

begin
  open o_cursor for io_select;
  ...
end;

But I receive an Oracle error. It indicateS that the previous statement expect for a "Select".

My ORACLE server is 7.3.3 with PL/SQL 2.3

Thanks you !

Received on Sun Jun 07 1998 - 04:18:09 CDT