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 -> 8.0.5 -> 8.1.6 PL/SQL Problem

8.0.5 -> 8.1.6 PL/SQL Problem

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Wed, 31 Jan 2001 22:45:21 +0100
Message-ID: <3A788771.CC52EC6C@0800-einwahl.de>

We found the following works in 8.0.5 (Sparc Solaris) but not in 8.1.6:

begin

        if nvl (5, ' ') = nvl (6, ' ') then
                null;
        end if;

end;
/

In 8.1.6.3.0 we get ORA-01722.

I found a init.ora setting of plsql_v2_compatibility which I set to true. However, this error persists.

Anyone got an idea?

Martin Received on Wed Jan 31 2001 - 15:45:21 CST

Original text of this message

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