Hi,

I have a field name as Achievement and its datatype is VarChar2 (4000Byte). When I am trying to insert data from the fron end it is giving me this error

"An exception was caught during the execution of an action query: ORA-01461: can bind a LONG value only for insert into a LONG column . Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception."

And the character limit which I am inserting is less then 4000. For testing purpose I was trying different combinations. It was allowing me to save the character limit for 2000 but when I was trying for more then that it was giving me error.

Where as I am able to insert data upto 4000 characters from the backend by writing a insert query and it is inserting data.

I have many fields like this and all of them are giving me the same problem.

What is the problem I am not trying to understand. Is LLblgen generating the correct query.

Please help me with this.

Thanks Monisha

Hi Monisha,

It seems like an old bug fixed (http://llblgen.com/TinyForum/Messages.aspx?ThreadID=9335).

Please post the LLBLGen version and runtime libraries version (http://llblgen.com/TinyForum/Messages.aspx?ThreadID=7725).

The llblgen version I am using is 2.0.0.0 Final. And runtime library version is 2.0.0.0

How do I get the new version so that this bug is solved.

Please let me know about this

Thanks Monisha.

Monisha,

Please read http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7725 to know how to obtain the runtime libraries version. That bug was fixed at 2.0.07.0319 build.

To obtain the latest version of the product, go to http://www.llblgen.com, then go to Customer area, go to downloads for v2.0, then download the full-version (recommended in this case) or the runtime libraries.

Cheers.

I have downloaded the full version. Do I just have to run the setup and this bug will be solved.

Thanks Monisha

You have to install the lastest version, then re-generate the code at LLBLGenPro Designer. (make a copy of your old code in the case something goes wrong).

Cheers

Thanks for the help. It worked.