Friday, 28 March 2014

java.sql.sqlexception ora-04063

Very often we tend to see this error while calling Database package/procedure from our oracle fusion middleware service.

Many times I have seen that this errror can be tackled easily with not much effort.I am not an admin guy so if you are a soa developer you can  try the below steps which might solve your problem.

Step 1 > Check if the procedure is running successfully on Ebiz side(end systems).

Step 2 > If error still persists try to recompile the code (procedure) from end systems.Many times it happens if source system makes any changes to existing procedure it needs good recomiple(min 2  times) to accept from middleware.

Step3: If error still persists try to call/invoke same  procedure again ,means if it fails on 1st attempt.


No comments:

Post a Comment