Re: PL/SQL complex selects

Hiya !

Well Well ! It works fine for me too ... Oracle 7.1.6 ....

Must be there is some problem at your end Gocha .... grill ur dba for it and see that he doesnt leave early for the weekend !

Cheers !

Mashya ...

In article <AAtSbGb0pst_at_soft-review.kiev.ua>,   igoryok_at_soft-review.kiev.ua wrote:
> χΤ 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)
>

--
Pls cc to : mashy_at_null.net , TA

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 02 1998 - 10:36:48 CDT