Thursday, June 30, 2011

FRM-40735: ON-INSERT trigger raised unhandled exception ORA-25207.

The queue needs to be restarted.

cd $AR_TOP/patch/115/sql
For Windows NT customer, please replace $AR_TOP with the proper path
Start SQL*Plus
sqlplus apps/apps
Run the script to start the queue: @arstque.sql
In some cases the queue will fail to start. If that happens then enter the
following:
sqlplus apps/apps
exec
dbms_aqadm.stop_queue(queue_name => 'AR.AR_REV_REC_Q');

exec
dbms_aqadm.drop_queue(queue_name =>'AR.AR_REV_REC_Q',
auto_commit=>TRUE);

exec dbms_aqadm.drop_queue_table(queue_table=>'AR.AR_REV_REC_QT',
force=>TRUE);

@arcquet.sql
@arstque.sql

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete