PLS-201 error after upgrade

From: Don Bowles <dbowles_at_praca.ksc.nasa.gov>
Date: 1997/08/26
Message-ID: <34030482.7731@praca.ksc.nasa.gov>#1/1

I have upgraded from 7.3.2.2 to 7.3.3.3 on HP-UX version 10.20. We cannot compile any package that uses a plsql table data type.

Here is a simple testcase.

Create or replace procedure oracle_test as

        Type r_Sc Is Record (
		fname	varchar2(50) Default NULL,
		valu	varchar2(500) Default NULL
	);
	Type t_Sc Is Table of r_Sc Index By Binary_Integer;
        scs  t_Sc;
begin
          scs(1).fname := 'this is a test';
	  scs(1).valu  := 'this is a test';
        if scs.exists(1) then
	     scs(2).fname := 'made it this far';
	end if;

end;
/

When compiling the following error occurs.

Errors for PROCEDURE ORACLE_TEST:

LINE/COL ERROR

-------- ---------------------------------------------------------
0/0      PLS-00201: identifier 'PLITBLM' must be declared
0/0      PLS-00201: identifier 'PLITBLM' must be declared
0/0      PLS-00201: identifier 'PLITBLM' must be declared
11/9     PL/SQL: Statement ignored

11/16 PLS-00302: component 'EXISTS' must be declared

Does anyone have any idea what the problem could be??

Note this procedure runs fine when ran against a Solaris 7.3.3 database.

TIA, Don Received on Tue Aug 26 1997 - 00:00:00 CDT