ORA-01461 during update of CLOB in ASP

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

ORA-01461 during update of CLOB in ASP

Post by hannes_a » Fri 03 Sep 2010 20:06

during update of a CLOB column a
ORA-01461: can bind a LONG value only for insert into a LONG column
is raised, I sent you a test project

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 07 Sep 2010 11:44

I cannot find your e-mail. Could you please send your test project to me (alexsh at devart*com) directly? Also please give us the information concerning the ORA-01461 error that we asked you in this thread.

hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Post by hannes_a » Sat 09 Oct 2010 10:35

I sent you a mail on
03.09.2010 22:05 to support size 3,7M
07.09.2010 20:15 to alexsh size 3,7M
08.09.2010 22:24 to alexsh, alexh size 5k
without any response

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 11 Oct 2010 14:08

Hannes, your letters were blocked by our e-mail system. Sorry for the inconvenience.
1. Please send me also the DDL/DML script for the database objects you are working with via data sources.
2. The exact steps we should follow to reproduce the ORA-01461 error.
3. The version of your Oracle Server.
4. Your current version of dotConnect for Oracle is 5.70.152 (Tools > Oracle > About), and you are using Direct Mode. Is this correct?

hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Post by hannes_a » Tue 12 Oct 2010 09:18

1: you can use the connect string in my example, the db in online over internet
2: try edit/update in grid (any value)
3: 11.2
4: 5.70.152
Shalex wrote:Hannes, your letters were blocked by our e-mail system. Sorry for the inconvenience.
1. Please send me also the DDL/DML script for the database objects you are working with via data sources.
2. The exact steps we should follow to reproduce the ORA-01461 error.
3. The version of your Oracle Server.
4. Your current version of dotConnect for Oracle is 5.70.152 (Tools > Oracle > About), and you are using Direct Mode. Is this correct?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 14 Oct 2010 09:49

We have just tried to connect to your database using the connection string from your project and received "A connection attempt failed...". Probably, a host with your database is turned off at the moment. Please notify us here or by e-mail (alexsh at devart dot com) when your database is available (tell us the date and the time in the GMT 0 format).

Otherwise, send us the DDL/DML script of your database objects (the REPORT table with its data). This is a better way.

hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Post by hannes_a » Mon 18 Oct 2010 12:20

I sent you a mail on 14.10.2010
My server is online since 14.10 till a solution is provided

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 19 Oct 2010 14:29

There are connection problems. We have answered you by e-mail with details.

hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Post by hannes_a » Thu 21 Oct 2010 08:16

I sent you DDL scripts by email

hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Post by hannes_a » Mon 25 Oct 2010 07:33

I figured out with Version 5.70.180 and direct connection
  • on Linux 64 with Oracle 11.2: no problem
    on Win7 64 with Oracle 11.1: problem exist
OCI usage does not suit my needs

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 26 Oct 2010 16:47

We have reproduced the error with Oracle Server v 11.1 and dotConnect for Oracle v 5.70.180. I will notify you about the results of our investigation.

hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Post by hannes_a » Fri 19 Nov 2010 14:42

are there any news ?
I found nothing about this in the 5.70.190 changelog

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 23 Nov 2010 15:22

The reason of "ORA-01461: can bind a LONG value only for insert into a LONG column" is that the OracleDataSource parameter of the"String" type is converted to OracleDbType.VarChar in all previous versions of dotConnect for Oracle (VarChar's max size is 4000 symbols). Starting from the next version, OracleDbType for parameter of the "String" type will be determined basing on its length (VarChar < 4000 < Clob).

If your version of dotConnect for Oracle is 5.70.170 or higher, you can use the following workaround: remove the Type attribute (Type="String") in Source Editor for parameter that corresponds to the Clob column in database - this will allow provider to determine the correct OracleDbType itself. This issue was discussed at http://www.devart.com/forums/viewtopic.php?p=58900.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 01 Dec 2010 12:36

New version of dotConnect for Oracle 6.00 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=19624 .

Post Reply