ORA-04091 Error
Posted: 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?
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?