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

From: Tim Gorman <tim@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 18 Mar 2013 08:12:03 -0600
It appears to be the output from the command "\dS <table-name>" from 
"psql" on a PostgreSQL database, so having a length of zero next to some 
datatypes may not mean what it would appear to mean on Oracle.

But this does offer some insight into the real problem being displayed 
here...

Jose, would it not be more effective to offer the output from the 
command "DESCRIBE GESTIONE_DOC_FILE" from SQL*Plus for the specific 
table into which the INSERT command is being executed? You are assuming 
that you have created the table appropriately on Oracle, and that the 
definition of the table on PostgreSQL is exactly the same, which (in 
light of the errors) is not a valid assumption at all. If you are going 
to diagnose problems on Oracle, it is important to do so where they are 
occurring.

Do not rely on assumptions. Obtain facts, and work from those facts. 
You'll get better results from your own troubleshooting, and you'll get 
more willing assistance from this list.



  On 3/18/2013 5:39 AM, rajugaru.vij@xxxxxxxxx wrote:
> One more interesting point, how come you have zero sized columns in your 
> table?
> Sent on my BlackBerry®
>
> -----Original Message-----
> From: rajugaru.vij@xxxxxxxxx
> Date: Mon, 18 Mar 2013 11:06:55
> To: <jose.soares@xxxxxxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
> Reply-To: rajugaru.vij@xxxxxxxxx
> 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@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
Re: ORA-01747: invalid user.table.column, table.column, or column specification

Other related posts:
