Re: select from (select...)

Hi Oren,

Your pl/sql is not type matched.

Do not use "select * from dual" as that this is pretty meaningless. Use "select sysdate from dual" or a literal or computed field that can be assigned to a variable.

-Lane

Oren Nakdimon wrote:

> 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 );
> end;
> /
>
> 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.
> =============================
> Oren Nakdimon
> Golden Screens Ltd.
> email: oren_at_gsit.co.il
> tel: +972-3-7510836
> fax: +972-3-7518221
> =============================

--
Lane Sharman
Pour chasser le chagrin,
il faut du vin.