Re: ORA-6552, ORA-6553
Date: Fri, 19 Nov 2004 15:17:42 -0800
Message-ID: <1100906176.639336_at_yasure>
Guenther Kober wrote:
> Hi!
>
> I'm "trying" to edit a fine-working existing script:
>
> SELECT COUNT (*)
> INTO the_count
> FROM TABLE_A
> WHERE ID = p_status;
>
> So, i wanted to change the table to TABLE_B and the where-clause to where
> TRANS_ID.
>
> But when I compile, I get the errors:
>
> 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
>
> The only difference is, that in the TABLE_B a column with the same name
> (TABLE_B) exists.
>
> Am I blind or what am I doing wrong?
>
> Best regards,
> -gue-
There is no way that your SQL statement, above, could cause an error with a timestamp column unless
- An old version of Oracle ... why didn't you tell us the version
- Running the SQL statement in an old or inadequate front-end
How about providing some more information if you want help.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Nov 20 2004 - 00:17:42 CET