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


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

Original text of this message