ORA-04091 Error

balu536 · Post by **balu536** » Mon Sep 19, 2011 4:50 am

Hi All,

I am getting the following error while inserting the data into a oracle table, by using the ODBC connector stage.

Here Oracle table name= 'ALARM'
Oracle Database Name =CATEGORY_DB'

ALARM_Insert_ODBC,1: ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 4,091: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-04091: table CATEGORY_DB.ALARM is mutating, trigger/function may not see it
ORA-06512: at "CATEGORY_DB.TI_AA", line 33
ORA-04088: error during execution of trigger 'CATEGORY_DB.ALARM' (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 695).

When I tried inserting the data manually. It is inserting properly into the database. When i am running the same insert query through data stage. I am getting this error.

Kindly help me. Is it an error from database stage or any other thing?

chulett · Post by **chulett** » Mon Sep 19, 2011 7:13 am

Did you research what exactly a ORA-04091 error is? Have you taken the error to your DBA? It generally means you have a trigger on the table and the trigger is not written correctly. See some examples here.