Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> select from (select...)
Hi.
I'm trying to do a query with sub-query in the FROM clause, in PL/SQL
(Oracle 7.3.3, PL/SQL 2.3.2.3.1 on Windows NT 4).
The sub-query is using some variables, and it's not working.
This is a simple example:
declare
a number;
r dual%rowtype;
begin
select *
into r
from ( select *
from dual where a=a );
declare
*
ERROR at line 1:
ORA-06550: line 7, column 9:
PLS-00320: the declaration of the type of this expression is incomplete
or
malformed
ORA-06550: line 5, column 4:
PL/SQL: SQL Statement ignored
When I don't use variables in the sub-query it works. It works also when I use the sub-query in the FROM clause of other statements (e.g. DELETE).
Can someone help me ?
Thanks, Oren.