ORA-01461: can bind a LONG value only for insert into a LONG column

Posts   
 
    
jbliss1234
User
Posts: 42
Joined: 04-May-2007
# Posted on: 20-Jun-2007 21:51:18   

We are using LLBLGen 2.0.0.0 (Final July 2006) and our database is Oracle 9i Rel2

We have a situation where a column is set as varchar2(4000), but an exception (ORA-01461) is thrown if the text inserted is more than ~2000 characters.

The suggested fix (at http://www.dotnet247.com/247reference/msgs/54/273793.aspx) is to not set the length of the parameter.

Also, it seems like this issue was fixed in LLBLGen way back in 2004 (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=1213&HighLight=1)

The question is: is this issue fixed in any of the recent updates (after July 2006). If not, can you please fix it?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39912
Joined: 17-Aug-2003
# Posted on: 20-Jun-2007 22:45:23   

Please try the latest build of the runtime libs. It should be fixed indeed in the current build.

Frans Bouma | Lead developer LLBLGen Pro