Saturday, March 5, 2011

ORA-01001 ERROR when creating trigger

Case : 

FRM-40735: ON-ERROR TRIGGER ORA-01001 FRM-42100 WHEN SEARCHING PARTIALLY PEOPLE

Problem:
In Users form, when trying to query by person field like ‘%name%’ an error message shows up:

FRM-40735: ON-ERROR TRIGGER RAISED UNHANDLED EXCEPTION ORA-01001
At alert_SID.log:
ORA-07445: exception encountered: core dump [qerixGetKey()+562] [SIGSEGV] [Address not mapped to object] [0x10] [] []
Cause:
Initialization parameters didn’t set properly for 10g.

Solution:
Add the follwing to initSID.ora file:
_b_tree_bitmap_plans = FALSE 

1 comment:

  1. have been try to create user's on oracle ebs r12 application. if i input the username and password i click save, i re-type the password again to set the user as active user, i click save, this error will prompt up: frm-40753 on-error trigger raised unhandled exception ora-01001, please anybody with solution should please help. you can post the solution online or communicate with me on mtnayor@yahoo.com. thanks

    ReplyDelete