Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! with PL/SQL
Nope, it is just that the PL/SQL syntax analyzer is a few hundreths behind in the versions compared to sql.
Use dynamic sql. It will work fine because the syntax analysis then is done by sql, not by pl/sql. Did it myself, and it worked pretty well. You can also lookup my statements in www.deja.com.
Martin
gdas_at_my-deja.com wrote:
>
> In article <8nk2r9$j8a$1_at_nnrp1.deja.com>,
> cosmin_ioan_at_my-deja.com wrote:
> > ... I do not believe you can use 'order by' in subqueries. I'm not
> > sure whether this is a limitation that can be lifted in future
> > versions. You may want to try other pl/sql structs or cursors within
> > cursors!? :-)
> >
> > Cosmin
> >
> Thanks for the reply. To confirm, you are saying this is a limitation
> specific to the PL/SQL Language. The statement does work as a standard
> sql statement and I was always led to believe that PL/SQL was a
> superset of SQL. Just wanted to make sure I understand.
> thanks,
> Gavin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 18 2000 - 14:57:06 CDT