ora-00957 duplicate column name on update when there's no duplicate
334405Jun 1 2004 — edited Jun 2 2004ORA-00957: duplicate column name on update
I;m executing this query:
update requisicoes set
requisicao_num = '4321',
requisicao_desc = 'dfgb',
empresa_id = 3,
posicao_id = 2,
solicitante = 'dfvsdfv',
centrodecusto_solicitante = '5131',
centrodecusto_executante = '5151',
centrodecusto_aplicacao = '5141',
data_saida = to_date('12/12/2004', 'dd/mm/yyyy'),
data_desejada = to_date('12/12/2004', 'dd/mm/yyyy'),
prioridade_id = 1,
observacao = 'sgfbfdgbdfgb',
posicao_id = 2
where requisicao_id = 3
But i'm getting this as an output:
posicao_id = 2
*
ERROR at line 14:
ORA-00957: duplicate column name
The problem is i cannot see any duplicate columns. What is the prlobme then?