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?
ORA-04091 Error
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers