SQL Developer Error
637717Jun 29 2009 — edited Jun 30 2009I keep getting the following error message when trying to execute a custom package:
Error starting at line 1 in command:
call xxnwu_bud_vacant_pkg.GET_POSITIONS ('31-JUL-2009', 3001)
Error report:
SQL Error: ORA-04063: package body "APPS.XXNWU_BUD_VACANT_PKG" has errors
04063. 00000 - "%s has errors"
*Cause: Attempt to execute a stored procedure or use a view that has
errors. For stored procedures, the problem could be syntax errors
or references to other, non-existent procedures. For views,
the problem could be a reference in the view's defining query to
a non-existent table.
Can also be a table which has references to non-existent or
inaccessible types.
*Action: Fix the errors and/or create referenced objects as necessary.
I called the package and it worked fine. I then added code but forgot to insert the ; at the end of the statement and it did not compile giving me an error message. I fixed the error and recompiled the package. When I tried to call the function again I got the above mentione error. I removed the changes I made so that the function would be the way it was when it did not give me an error but it still gives me the error even though it is the same code that worked an hour ago. The package compiles without any errors but I keep getting the error above.
Does anyone have any advice??
I have tried SQL Developer 1.5.1 & 1.2.1
I have tried to drop the package and re-create it but it does not solve my problem.
Thanks
Roald