Re: Ref Cursor question

Your problem with the SQL that works from SQL*Plus but not in PL/SQL is the in-line view. Your version of Oracle is running at a level where PL/SQL is not yet capable of handling in-line views.

Your requirement for

>CREATE OR REPLACE PROCEDURE RETURN_RESULT_SET
> (oCursor IN OUT MyPkg.CursorType,
> AColumn IN VARCHAR,
> AValue IN VARCHAR) as
>BEGIN
> open oCursor for
> select * from ATable where AColumn like AValue||%
>END;
>

has to be handled using the dbms_sql package. Received on Sun Feb 07 1999 - 03:23:42 CST