Re: PL/SQL complex selects

χΤ 29 ΣΕΞ 98 "Gocha Mchedlishvili" (gocham_at_mci2000.com) wrote:

> Hi!

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?

At my Oracle8.0.4. all works fine:

declare
  cursor aCursor is select * from (select * from mytable); begin
  for aRow in aCursor loop
    null;
  end loop;
end;

--
Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)

Igor V. Podolsky (igoryok_at_soft-review.kiev.ua) Received on Fri Oct 02 1998 - 03:57:47 CDT