Re: PL/SQL complex selects

From: howard <howard.lee_at_connection.com.hk>
Date: Wed, 30 Sep 1998 16:52:33 +0800
Message-ID: <3611F151.9392B255@connection.com.hk>

is there any differece between your statement and DECLARE
CURSOR MYCURSOR IS SELECT * FROM MYTABLE? thanks
howard

Gocha Mchedlishvili wrote:

> Hi!
>
> I tried to create cursor in procedure like
>
> DECLARE
> CURSOR MyCursor IS
> SELECT * FROM ( SELECT * FROM MyTable)
>
> But I'm getting an error, I'm also getting the same error when I'm trying to
> use complex select anywhere in procedure. Is it possible to use complex
> select in procedure?
>
> Thanks,
>
> Gocha
Received on Wed Sep 30 1998 - 03:52:33 CDT