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

From: <rajugaru.vij_at_gmail.com>
Date: Mon, 18 Mar 2013 15:20:54 +0000
Message-ID: 1482123437-1363620051-cardhu_decombobulator_blackberry.rim.net-1041396254-_at_b28.c12.bise7.blackberry>

"id_catalogazione_modulistica" this one is issue here.. Can you rename the column and decrease its size, then try again.. Should work

Sent on my BlackBerry®

-----Original Message-----
From: Jose Soares <jose.soares_at_sferacarta.com> Date: Mon, 18 Mar 2013 15:54:27
To: <rajugaru.vij_at_gmail.com>; <oracle-l_at_freelists.org> Subject: Re: ORA-01747: invalid user.table.column, table.column, or column  specification

I tried with double quotes as you suggested and now I get a different error: (DatabaseError) ORA-00972: identifier is too long

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 ('1',
'2013.02.19-12.28.30.odt',
'verbale controllo ufficiale',
NULL,

'2013-02-19 12:25:09.758310',
'111112',
'2013-02-19',

NULL,

'6',
'443',
'R',
'unita_aziendale',
'69908',
'69908',
'2013-02-19 12:28:30.558803',

NULL,
NULL,
'6',
NULL); (DatabaseError) ORA-00972: identifier is too long   'insert into gestione_doc_file (\n "id",\n "nomefile",\n

"nome_visualizzato",\n "descrizione",\n "data_creazione",\n 
"protocollo",\n "data_protocollo",\n "tipo_file",\n "id_operatore",\n 
"id_catalogazione_modulistica",\n "tipo_documento",\n 
"nome_tabella_proven",\n "chiave_tabella_proven",\n 
"id_unita_aziendale",\n "ts_ultima_modifica",\n "cod_argomento",\n 
"ts_annullamento",\n "id_operatore_modifica",\n " where rownum <= 

e_conservazione") \nvalues
(\'1\',\n\'2013.02.19-12.28.30.odt\',\n\'verbale controllo ufficiale\',\nNULL,\n\'2013-02-19
12:25:09.758310\',\n\'111112\',\n\'2013-02-19\',\nNULL,\n\'6\',\n\'443\',\n\'R\',\n\'unita_aziendale\',\n\'69908\',\n\'69908\',\n\'2013-02-19 12:28:30.558803\',\nNULL,\nNULL,\n\'6\',\nNULL)' {}

On 03/18/2013 12:48 PM, rajugaru.vij_at_gmail.com wrote:
> Use double quotes for all the column names in the query, that should do..

>

> Let me know if that helps.

>

> 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 - 16:20:54 CET