Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Proc Compilation Error

Re: Stored Proc Compilation Error

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 18 Oct 2004 21:10:25 -0700
Message-ID: <1098158973.739965@yasure>


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)
Received on Mon Oct 18 2004 - 23:10:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US