This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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.