Re: Stored Proc Compilation Error

dallas_coder wrote:

> 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

It isn't a reserved word. To find them all ... SELECT keyword
FROM v$reserved_words;

So your problem is your syntax which you felt it unnecessary to post.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)