PLS-00313: 'IS NOT NULL' not declared in this scope
From: Janet C. Mesina <cos_at_inel.gov>
Date: 1996/06/01
Message-ID: <4oqd9g$a83_at_mica.inel.gov>#1/1
BEGIN
Date: 1996/06/01
Message-ID: <4oqd9g$a83_at_mica.inel.gov>#1/1
I am in the process of compiling PL/SQL packages in the Orace7 Server Release 7.2.2.3.0 running PL/SQL Release 2.2.2.3.0.
These packages compiled in the Oracle7 Server Release 7.0.16.4.1 running PL/SQL Release 7.13.
The problem occurs when an "IS NULL" or "IS NOT NULL" statement is found in the package body. The error reported is: PLS-00313: 'IS NOT NULL' not declared in this scope
An example of the code that caused this error is:
PROCEDURE determine_end_month (v_bsu_actl_end_date IN ip_bsu_tab.bsu_actl_end_date%TYPE, v_tmp_fymon_id IN OUT ip_fymon_tab.fymon_id%TYPE)IS
BEGIN
DBMS_OUTPUT.PUT_LINE('determine_end_month'); -- Determine Fiscal Complete Date IF ( v_bsu_actl_end_date IS NOT NULL) THEN
Any good ideas?
thanks
J Mesina
-- There are two kinds of failures: those who thought and never did and those who did and never thought. J Mesina Email: cos_at_inel.gov Software Analysis & Integration Eng. mes_at_snake.srv.net Idaho National Engineering Lab. Phone: (208)526-0386 P.O. Box 1625 Fax: (208)526-8939 Idaho Falls, ID 83415-3818 _/_/_/_/ _/ _/ _/_/_/_/ _/ _/ _/_/ _/ _/ _/ _/ _/ _/ _/ _/_/_/ _/ _/ _/ _/_/ _/ _/ _/_/_/_/ _/ _/ _/_/_/_/ _/_/_/_/Received on Sat Jun 01 1996 - 00:00:00 CEST