ORA-6552, ORA-6553

[Quoted] 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- Received on Thu Nov 18 2004 - 18:44:46 CET