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

From: Charles Jardine <cj10_at_cam.ac.uk>
Date: 1996/06/05
Message-ID: <31B56231.4B71_at_cam.ac.uk>#1/1

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

It sounds as though PL/SQL is not properly installed in the 7.2 database. Ask the DBA to run catproc.sql (as SYS). It is harmless to run it twice. Received on Wed Jun 05 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Robert Cook: "Re: SQL*NET V2 On A Shared File Server"
Previous message: Dieter Oberkofler: "Re: RFD: comp.databases.oracle reorganization"
In reply to: Janet C. Mesina: "PLS-00313: 'IS NOT NULL' not declared in this scope"
Next in thread: Robert Cook: "Re: SQL*NET V2 On A Shared File Server"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message