I have a procedure which is perfectly fine when executing from SQL developer by using statement :
Begin
procedure_name;
End;
/
But when I am trying to run this procedure through a shell script being called from a job scheduler software it is failing with error 'ora-12839 cannot modify an object'. I have already done killing the inactive sessions and restarting the database. Can anyone suggest what may be the exact problem?