Did you do "show errors"? to find out what the error is. What you posted is like saying, this here is my haystack, I dropped something small in it, like a needle, but not necessarily a needle. Now Go Git It! Are you using Toad? you can step through your code in Toad (heh it rhymes) and find out which line has the error. Mark
Thanks. Yes, I am using Toads.it is giving a nonsense message.For example when I put the declare statement it complains about that. Also I get the following error on my variable declaration: PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: := . ( @ % ; The symbol ":=" was substituted for "VARCHAR2" to continue.