Home » SQL & PL/SQL » SQL & PL/SQL » Error Executing Package/Procedure
Error Executing Package/Procedure [message #432548] Tue, 24 November 2009 20:40 Go to next message
sabu
Messages: 1
Registered: November 2009
Location: Australia
Junior Member
Hi all,

I am receiving the following error messages when trying to execute any procedure as apart of a certain package
ORA-04063: package body "APEX_BPCC.RIGHTNOW_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APEX_BPCC.RIGHTNOW_PKG"
ORA-06512: at line 2


I'm a little confused as to how/why this is happening as no code has been changed within the procedure/package since it was run last & other packages are running OK.

I'm a bit of an Oracle newbie - can someone please guide me to diagnose this?

Thanks,

Sebastian
Re: Error Executing Package/Procedure [message #432549 is a reply to message #432548] Tue, 24 November 2009 21:18 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
ORA-06508: PL/SQL: could not find program unit being called

Cause: An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors.

Action: Check that all referenced programs, including their package bodies, exist and are compatible.



sriram Smile

[Updated on: Wed, 25 November 2009 00:47] by Moderator

Report message to a moderator

Previous Topic: Row Generator And Serial Number
Next Topic: Integer Vs Number Datatype
Goto Forum:
  


Current Time: Sun Sep 25 19:42:08 CDT 2016

Total time taken to generate the page: 0.07611 seconds