ORA-6552, ORA-6553

[Guenther Kober]

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-

[Guenther Kober]

i think, i have the "error": in table_a is a column of type "timestamp(6)".
no idea, where it comes from, but this is the thing which seems to make
trouble. after dropping the column, my procedure is compilable. (of course i
didn't drop the column - i created a view without the column ;-) )

[DA Morgan]

There is no way that your SQL statement, above, could cause an error
with a timestamp column unless

1. An old version of Oracle ... why didn't you tell us the version
2. 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
damo...@x.washington.edu
(replace 'x' with 'u' to respond)