Re: Stored Proc Compilation Error

Just my 2 Cents on this...

The problem could not necessarily be related to the name of the table. If there is a column in the table that is sharing the same name as an Oracle keyword albeit within quotes like

Create table t1 (
"Date" date,
"Number" number );

then we may encounter the same problems during execution of the procedure. Check for the same condition in any of the tables referenced in your procedure.
Let me know if this was the problem in your case.

Vicchu

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
>
>
>
Received on Mon Oct 18 2004 - 10:51:08 CDT