Compilation unit analysis terminated- SOLVED

As a newbie, I got the following error

Error: PL/SQL: Compilation unit analysis terminated Error(1,14): PLS-00905: object NAMEEMP.AMERGDIR is invalid Error(1,14): PLS-00304: cannot compile body of 'AMERGDIR' without its specification

I spent a few hours in trying to solve this. What caused my error was in the package,
(NOT THE BODY) I had

Function mystuff( v_sql_tx varchar2(100)) RETURN varchar2;

I should have had

Function mystuff( v_sql_tx varchar2) RETURN varchar2;

I hope this helps someone else.
Thanks.
Steve Received on Fri Jan 19 2007 - 08:55:24 CST