Re: ORA-01747: invalid user.table.column, table.column, or column specification

From: <rajugaru.vij_at_gmail.com>
Date: Mon, 18 Mar 2013 11:06:55 +0000
Message-ID: 1016632548-1363604812-cardhu_decombobulator_blackberry.rim.net-731473139-_at_b28.c12.bise7.blackberry>

Hi,
You are using some oracle keyword. Please send me the list of field names. So that can help you find the exact issue.

Thanks
Sent on my BlackBerry®

-----Original Message-----
From: Jose Soares <jose.soares_at_sferacarta.com> Sender: oracle-l-bounce_at_freelists.org Date: Mon, 18 Mar 2013 11:56:22
To: <oracle-l_at_freelists.org>
Reply-To: jose.soares_at_sferacarta.com
Subject: ORA-01747: invalid user.table.column, table.column, or column specification

Hi all,

This time I got the error ORA-01747: invalid user.table.column, table.column, or column specification
in this query and I can't find the error. Please could someone help me?

---

insert into gestione_doc_file
(id,nomefile,nome_visualizzato,descrizione,data_creazione,protocollo,data_protocollo,tipo_file,id_operatore,id_catalogazione_modulistica,tipo_documento,nome_tabella_proven,chiave_tabella_proven,id_unita_aziendale,ts_ultima_modifica,cod_argomento,ts_annullamento,id_operatore_modifica,limite_conservazione)
values ('544','2013.02.19-12.21.22.odt',NULL,'2013-02-19 12:21:22.951426',NULL,NULL,NULL,NULL,'443','C',NULL,NULL,NULL,'2013-02-19 12:21:22.951426',NULL,NULL,NULL,NULL,NULL); ORA-01747: invalid user.table.column, table.column, or column specification

this is the table schema:

name                        | type                       | length| 

nullable| default

----------------------------+ ---------------------------+ ------+ 
--------+ ------------------
chiave_tabella_proven       | nvarchar2                  | 600   | 
Y       | NULL
cod_argomento               | nvarchar2                  | 10    | 
Y       | NULL
data_creazione              | timestamp(6) with time zone| 0     | 
N       | CURRENT_TIMESTAMP
data_protocollo             | date                       | 0     | 
Y       | NULL
descrizione                 | nvarchar2                  | 200   | 
Y       | NULL
id                          | number                     | 0     | 
N       | NULL
id_catalogazione_modulistica| number                     | 0     | 
Y       | NULL
id_operatore                | number                     | 0     | 
Y       | NULL
id_operatore_modifica       | number                     | 0     | 
Y       | NULL
id_unita_aziendale          | number                     | 0     | 
Y       | NULL
limite_conservazione        | date                       | 0     | 
Y       | NULL
nomefile                    | nvarchar2                  | 500   | 
N       | NULL
nome_tabella_proven         | nvarchar2                  | 100   | 
Y       | NULL
nome_visualizzato           | nvarchar2                  | 200   | 
Y       | NULL
protocollo                  | nvarchar2                  | 100   | 
Y       | NULL
tipo_documento              | nvarchar2                  | 1     | 
N       | NULL
tipo_file                   | nvarchar2                  | 30    | 
Y       | NULL
ts_annullamento             | timestamp(6) with time zone| 0     | 
Y       | NULL
ts_ultima_modifica          | timestamp(6) with time zone| 0     | 
N       | CURRENT_TIMESTAMP

(19 rows)

thanks for any help
j

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 18 2013 - 12:06:55 CET