merge statement is not working

mr-sansibar · #1 (**permalink**) 06-29-12, 07:34

when i execute below staying statememt, this message appears. maybe merge is not supported in Oracle9i Release 9.2.0.5.0:

meesage: 13:32:20 [MERGE - 0 row(s), 0.000 secs] [Error Code: 907, SQL State: 42000] ORA-00907: Rechte Klammer fehlt

Code:

merge into TIME.KOM_GEH@link_to_arttest t
using (select * from TIME.KOM_GEH) timesheet
on (
t.RN=timesheet.RN
t.KOMMEN=timesheet.KOMMEN
t.GEHEN=timesheet.GEHEN
t.PAUSE_H=timesheet.PAUSE
)
when matched then
0=0
when not machted then
insert () values (timesheet.RN, timesheet.KOMMEN, timesheet.GEHEN, timesheet.PAUSE);

thank you.

anacedent · #2 (**permalink**) 06-29-12, 09:56

>maybe merge is not supported in Oracle9i Release 9.2.0.5.0:

when all else fails Read The Fine Manual

SQL Statements: DROP SEQUENCE to ROLLBACK, 15 of 19

beilstwh · #3 (**permalink**) 06-29-12, 10:02

The error indicates that the Right parenthesis is missing. instead of typing it in, cut and paste the actual merge command.

kordirko · #4 (**permalink**) 06-29-12, 10:19

Merge is supported starting from Oracle 10.
Anyway, your statement has syntax errors

Code:

merge into TIME.KOM_GEH@link_to_arttest t
using (select * from TIME.KOM_GEH) timesheet
on (
t.RN=timesheet.RN
AND
t.KOMMEN=timesheet.KOMMEN
AND
t.GEHEN=timesheet.GEHEN
AND
t.PAUSE_H=timesheet.PAUSE
)
when not machted then
insert (
  -- column list of t is required here, separate columns with comma
  column1, col2, col3, col4
) values (timesheet.RN, timesheet.KOMMEN, timesheet.GEHEN, timesheet.PAUSE);

anacedent · #5 (**permalink**) 06-29-12, 10:22

>Merge is supported starting from Oracle 10.
See URL posted above which indicates otherwise

Internet Services

Web Development

Digital Marketing

Consumer Tech