Re: ORA-01747: invalid user.table.column, table.column, or column specification
Date: Mon, 18 Mar 2013 08:12:03 -0600
Message-ID: <514720B3.1030005_at_evdbt.com>
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_at_gmail.com wrote:
> 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-lReceived on Mon Mar 18 2013 - 15:12:03 CET