Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> NVL2 in PL/SQL 10g
<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:
![]() |
![]() |