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

From: <rajugaru.vij_at_gmail.com>
Date: Mon, 18 Mar 2013 11:39:09 +0000
Message-ID: 366012634-1363606752-cardhu_decombobulator_blackberry.rim.net-1910831954-_at_b28.c12.bise7.blackberry>

One more interesting point, how come you have zero sized columns in your table? Sent on my BlackBerry®

-----Original Message-----
From: rajugaru.vij_at_gmail.com
Date: Mon, 18 Mar 2013 11:06:55
To: <jose.soares_at_sferacarta.com>; <oracle-l_at_freelists.org> Reply-To: rajugaru.vij_at_gmail.com
Subject: Re: ORA-01747: invalid user.table.column, table.column, or column specification

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:39:09 CET