Re: PLS-00313: 'IS NOT NULL' not declared in this scope

The solution to problems like these is to relink Oracle with PL/SQL (if it hasn't already been done) and to rerun the 'catproc.sql' script found in ?/rdbms/admin as SYS.

In article <31B448B3.3233_at_wizard.colorado.edu>, carl sorenson <sorenson_c_at_wizard.colorado.edu> writes:
|> I had this same problem at my installation, which is running
|> 7.1. My DBA just fixed it yesterday. I don't know exactly
|> what she did, but she said she fixed something having to do
|> with 'the procedural option.' This also fixed another problem
|> i was having - the GREATEST function was not working in pl/sql.
|>
|> Carl Sorenson
|>
|>
|> Janet C. Mesina wrote:
|> >
|> > 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
|> >
|> > _/_/_/_/ _/ _/ _/_/_/_/ _/
|> > _/ _/_/ _/ _/ _/
|> > _/ _/ _/ _/ _/_/_/ _/
|> > _/ _/ _/_/ _/ _/
|> > _/_/_/_/ _/ _/ _/_/_/_/ _/_/_/_/
 

-- 
------------------------------------------------------------------------
Scott Urman            Oracle Corporation           surman_at_us.oracle.com
------------------------------------------------------------------------
Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2
Published by Oracle Press - http://www.osborne.com/oracle/index.htm
------------------------------------------------------------------------
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"
------------------------------------------------------------------------