Re: Am I imagining things?

From: Andy Hassall <andy_at_andyh.org>
Date: Thu, 11 Apr 2002 13:00:25 +0100
Message-ID: <0auabu01ut6kd0n29pgc23ake44ish66es@4ax.com>

On Thu, 11 Apr 2002 11:26:25 GMT, nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote:

>Anyone here with 9.0.1.1 for NT installed on W2K?
>Please do the following:

SQL*Plus: Release 9.0.1.0.1 - Production on Thu Apr 11 12:53:09 2002

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production JServer Release 9.0.1.1.1 - Production

SQL> set pause on pause 'Press Return to continue...' SQL> select * from dual;
Press Return to continue...

D
-
X

SQL> No problem there.

>Also, a bone to pick ewith Mr. Oracle:
>We were told that SQL and PL/SQL now had the same parser.
>OK, says I: I can now use SQL conditions in my PL/SQL IF statement.

It's now the same parser for SQL statements within PL/SQL, i.e. for cursors.

Previously you were unable to use new 8i keywords such as CASE or NVL2 within PL/SQL cursors, as the SQL parsers were separate and the new keywords only implemented in the 'plain' SQL parser.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production

SQL> select NVL2(DUMMY, 'a', 'b') from DUAL;

N
-
a

SQL> declare
  2 v varchar2(1);
  3 begin
  4 select NVL2(DUMMY, 'a', 'b') into v from DUAL;   5 end;
  6 /
select NVL2(DUMMY, 'a', 'b') into v from DUAL;

*
ERROR at line 4:

ORA-06550: line 4, column 9:
PLS-00201: identifier 'NVL2' must be declared
ORA-06550: line 4, column 2:

PL/SQL: SQL Statement ignored

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production JServer Release 9.0.1.1.1 - Production

SQL> select NVL2(DUMMY, 'a', 'b') from DUAL;

N
-
a

SQL> declare
  2 v varchar2(1);
  3 begin
  4 select NVL2(DUMMY, 'a', 'b') into v from DUAL;   5 end;
  6 /

PL/SQL procedure successfully completed.

-- 
Andy Hassall (andy@andyh.org) icq(5747695) http://www.andyh.org
http://www.andyh.uklinux.net/space | disk usage analysis tool

Received on Thu Apr 11 2002 - 07:00:25 CDT