Stored Proc Compilation Error

From: dallas_coder <w5ww_at_yahoo.com>
Date: 18 Oct 2004 07:02:30 -0700
Message-ID: <1098108150.473759.191540@c13g2000cwb.googlegroups.com>

To All,

I'm working on a database conversion project. The new database is Oracle 9i. The conversion process is able to create a table named HISTORY and load data. The problem occurs when I try to create a stored procedure that references the table. The following error occurs.

PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed

I've been through various Oracle manuals and cannot find any documentation that says HISTORY is an Oracle reserve word or Oracle keyword.

Anyone else have this problem?

Thanks - DC Received on Mon Oct 18 2004 - 09:02:30 CDT