ORA-0462: Signature Of Packages "SYS.DBMS_LOB" Has Been Changed Saving New Case (Doc ID 859862.1)

Last updated on JANUARY 10, 2014

Applies to:

Adverse Event Reporting System - Version 4.6.0 and later
Information in this document applies to any platform.

***Checked for relevance on 11-JUL-2011***
***Checked for relevance on 10-JAN-2014***


Symptoms

On 4.6.1 on a new installation:


When attempting to run through the Smoke Test Document and save a new case
the following error occurs:


ERROR
ORA-40735 ON-INSERT trigger raised unhandled exception ORA-04062
ORA-0462: signature of packages "SYS.DBMS_LOB" has been changed.
[OK]



Steps To Reproduce:
The issue can be reproduced at will with the following steps:

 

  1. AERS 4.6.1
  2. Log in as Drug Manager (or indeed any user)
  3. Add New Case Details per the AERS 4.6 Smoke test document
  4. On Saving case the following warning is output:

    ORA-40735 ON-INSERT trigger raised unhandled exception ORA-04062
    ORA-0462: signature of packages "SYS.DBMS_LOB" has been changed.
    [OK]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms