DSXchange

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.

Can you try splitting the job into two steps and see if you still get the same error...

individually insert and update is working fine

But When we use UPSERT its showing this error

what is the array size ?

Array size is 1

what are the column names in queries that get generated.. im hoping none of them are oracle reserve words

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..

No its just a temp job to test
i dint copy any metadata or stages from any other job

Split into your own post.

Please don't "me too" on the end of older posts, always start your own and then (if it seems like it would help) link to the older post.