Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> NVL2 in PL/SQL 10g

NVL2 in PL/SQL 10g

From: klabu <klabu76_at_gmail.com>
Date: 4 Feb 2007 13:09:49 -0800
Message-ID: <1170623389.418883.204610@q2g2000cwa.googlegroups.com>


<10gR2>

so is it a fact that NVL2 can NOT be used in PL/SQL ??? Quite surprised to find.
But was REALLY surprised that I can not find confirmation by googling (yet)

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> DECLARE
  2 l_test VARCHAR2(30) := 'hi';
  3 BEGIN
  4 l_test := nvl2('hello','world','earth');   5 END;
  6 /
    l_test := nvl2('hello','world','earth');

              *
ERROR at line 4:

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

PL/SQL: Statement ignored Received on Sun Feb 04 2007 - 15:09:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US