2010-04-12

EUL5_BATCH_USER

An error message is displayed whenever you try to submit a scheduled workbook as a Discoverer user(note 282829.1):

Database Error - ORA-04068: existing state of packages has been discarded
ORA-04063: package body
".EUL5_BATCH_USER" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2


Cause:
After giving 'Schedule workbook' privilege to user, eul5_batch_user package was invalid due to sys.v_$parameter cannot be accessed by the Discoverer user



grant select on sys.v_$parameter to ....

ALTER PACKAGE eul5_batch_user COMPILE PACKAGE;

Also, check if the user has the right to create jobs, tables, views, enough quota.

  

Niciun comentariu:

Trimiteți un comentariu