Re: PL/SQL error after upgrade to 7.1.3.2.1 from 7.0.16.4.1

You need to run the data dictionary scripts for version 7.1. Under $ORACLE_HOME/rdbms/admin, run catproc.sql as SYS.

In article <Pine.OSF.3.90.940921123941.31574B-100000_at_holmes.sgate.com>, Peggy Hwu <hwupeggy_at_holmes.sgate.com> writes:
|> Hi!
|>
|> We have just upgraded to ORACLE 7.1.3.2.1 and PL/SQL 2.1.3.2.0
|> from ORACLE 7.0.16.4.1.
|>
|> We now get errors in PL/SQL scripts that worked successfully before.
|>
|> The error occurs when "IS NULL" or "IS NOT NULL" is in a WHERE-clause
|> of a PL/SQL script. PL/SQL does not recognize it. A sample execution
|> is shown at the end of this message.
|>
|> Have any of you who have upgraded to 7.1 experienced this problem?
|> What workarounds/solutions have you all used?
|>
|> We running ORACLE on a DEC Alpha running OSF/1 v.3.0.
|>
|> Thanks for your time!
|>
|> Sincerely,
|> Peggy Hwu
|>
|> ***************************************************************************
|> SAMPLE EXECUTION:
|> ***************************************************************************
|>
|> SQL*Plus: Release 3.1.3.4.1 - Production on Wed Sep 21 09:16:06 1994
|>
|> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
|>
|>
|> Connected to:
|> Oracle7 Server Release 7.1.3.2.1 - Production Release
|> PL/SQL Release 2.1.3.2.0 - Production
|>
|> SQL> declare
|> 2 frame_num crl_data.frame_to%type;
|> 3 begin
|> 4 select frame_to into frame_num from crl_data where
|> 5 frame_to is null and cable_number = 'WA2CU0002' and line_number = 1;
|> 6 end;
|> 7 /
|> frame_to is null and cable_number = 'WA2CU0002' and line_number = 1;
|> *
|> ERROR at line 5:
|> ORA-06550: line 5, column 1:
|> PLS-00313: 'IS NULL' not declared in this scope
|> ORA-06550: line 4, column 1:
|> PL/SQL: SQL Statement ignored
Received on Wed Sep 21 1994 - 20:05:59 CEST