ORA-00934: group function is not allowed here
Moderators: chulett, rschirm, roy
ORA-00934: group function is not allowed here
I am getting the same error as noted here when tried to UPSERT using oracle connector in datastage 8.5
the auto generated query :
The connector generated the following RETURNING statement at runtime: UPDATE SIDBOR_ETL.tmp_1 SET C=:c,B=:b WHERE A=:a RETURNING COUNT(ROWID) INTO :3.
The connector generated the following UPDATE statement at runtime: UPDATE SIDBOR_ETL.tmp_1 SET C=:c,B=:b WHERE A=:a.
The connector generated the following INSERT statement at runtime: INSERT INTO SIDBOR_ETL.tmp_1(C,A,B) VALUES(:c,:a,:b).
Eventhough i tried with custom query ,But iam getting the same error
Oracle_Connector_3,1: The OCI function OCIStmtExecute returned status -1. Error code: 934, Error message: ORA-00934: group function is not allowed here. (CC_OraStatement::executeUpdate, file CC_OraStatement.cpp, line 1996)
Can any one help me with this error.
the auto generated query :
The connector generated the following RETURNING statement at runtime: UPDATE SIDBOR_ETL.tmp_1 SET C=:c,B=:b WHERE A=:a RETURNING COUNT(ROWID) INTO :3.
The connector generated the following UPDATE statement at runtime: UPDATE SIDBOR_ETL.tmp_1 SET C=:c,B=:b WHERE A=:a.
The connector generated the following INSERT statement at runtime: INSERT INTO SIDBOR_ETL.tmp_1(C,A,B) VALUES(:c,:a,:b).
Eventhough i tried with custom query ,But iam getting the same error
Oracle_Connector_3,1: The OCI function OCIStmtExecute returned status -1. Error code: 934, Error message: ORA-00934: group function is not allowed here. (CC_OraStatement::executeUpdate, file CC_OraStatement.cpp, line 1996)
Can any one help me with this error.
Sorry, I guess thats a silly question - since you have already used the same metadata to do seperate INSERT/UPDATE query tests.
Could you try deleting that stage and redoing the properties with a new one to ensure you havent got anything hanging in it from another query/job if you copied the stage from somewhere else..
Could you try deleting that stage and redoing the properties with a new one to ensure you havent got anything hanging in it from another query/job if you copied the stage from somewhere else..