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

  • From: rajugaru.vij@xxxxxxxxx
  • To: jose.soares@xxxxxxxxxxxxxx,oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 18 Mar 2013 11:06:55 +0000

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@xxxxxxxxxxxxxx>
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Date: Mon, 18 Mar 2013 11:56:22 
To: <oracle-l@xxxxxxxxxxxxx>
Reply-To: jose.soares@xxxxxxxxxxxxxx
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

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


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2013