Re: PL/SQL complex selects

From: R Fray <russ_at_u-net.net>
Date: Wed, 30 Sep 1998 08:42:42 GMT
Message-ID: <3611eef1.421741862@news.u-net.com>

On Tue, 29 Sep 1998 21:46:24 -0400, "Gocha Mchedlishvili" <gocham_at_mci2000.com> 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?

Would be useful if you posted the error Gocha...

Russ.

Russell Fray
U-NET Ltd. Received on Wed Sep 30 1998 - 03:42:42 CDT