Re: Oracle packages

odeborne_at_hotmail.com (Olivier Deborne) wrote in message news:<b0c018e3.0211210657.6c02b2e5_at_posting.google.com>...
> SELECT level,
> PART_NO,
> (SELECT DESCRIPTION FROM INVENTORY_PART WHERE PART_NO =
> RECIPE_STRUCTURE.PART_NO) PART_DESCRIPTION,
> LINE_SEQUENCE,

...
> It compiles just fine on my server (ora 90) but on another server
> which runs Oracle 8.0.1.7 I get the following error:
>
> PLS-00103: Encountered the symbol "SELECT" when expecting one of the
> following:
>
> ( - + mod not null others <an identifier>
> <a double-quoted delimited-identifier> <a bind variable> avg
> count c

I don't have 8.0.1.7 around. But 8.0.5 doesn't seem to support the expression in the SELECT clause. Try this on your 9i and 8.0 database to find out:

select username, (select user_id from user_users) userid from user_users;

Yong Huang Received on Thu Nov 21 2002 - 13:50:58 CST