Very simple. In Oracle 7.x, PL/SQL DOES NOT support inline views but it
works in Oracle 8.
> 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 Tue Oct 06 1998 - 07:45:22 CDT
