Re: PL/SQL complex selects

From: <sokol_at_opsb.ru>
Date: Wed, 30 Sep 1998 15:38:45 GMT
Message-ID: <6utja5$kvm$1@nnrp1.dejanews.com>

> 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
>
>

Your PL/SQL machine too old for complex queries

Use PL/SQL 8.x and all OK!.

Luck.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 30 1998 - 10:38:45 CDT