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
