Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cursor using select from subquery
Solomon.Yakobson_at_entex.com wrote:
>
> Starting 7.2 it is perfectly legal to use subquery in FROM clause
> both in SQL and PL/SQL.
Not in PL/SQL in 7.2!
Oracle7 Server Release 7.2.3.0.0 - Production Release PL/SQL Release 2.2.3.0.0 - Production
SQL> declare x varchar2;
2 begin
3 select dummy into x from
4 ( select * from dual);
5 end;
6 /
( select * from dual);
*
ERROR at line 4:
ORA-06550: line 4, column 1: PLS-00103: Encountered the symbol "(" when expecting one of the following: