Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cursor using select from subquery

Re: cursor using select from subquery

From: Charles Jardine <cj10_at_cam.ac.uk>
Date: 1997/02/05
Message-ID: <32F86C8F.7DB2@cam.ac.uk>#1/1

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:

<an identifier> <a double-quoted delimited-identifier> Received on Wed Feb 05 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US