Re: 8i bug(s)?

On 26 Oct 2004 11:15:06 -0700, sdbillsfan_at_gmail.com (Will) wrote:

>PROBLEM #2
>The script below also works fine on 9i but the pl/sql block produces
>the following output on an 8i box(Once again, the statement outside
>the block still works as expected):
>
>ERROR at line 5:
>ORA-06550: line 5, column 11:
>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 current exists max min prior sql stddev sum variance
>execute forall time timestamp interval date
><a string literal with character set specification>
><a number> <a single-quoted SQL string>
>ORA-06550: line 5, column 31:
>PLS-00103: Encountered the symbol "+" when expecting one of the
>following:
>; return returning and or
>
>
>************* begin script
>select (select 1 from dual) + (select 2 from dual) as total from dual;
>
>declare
>v_count number;
>begin
>
> select ((select 1 from dual) + (select 2 from dual)) into v_count
>from dual;
>
>end;
>/
>************* end script

8i has a sql engine and a pl/sql engine. The pl/sql engine lags behind in functionality. All discrepancies have been removed in 9i.

--
Sybrand Bakker, Senior Oracle DBA