0

In an Oracle 11 database I have a table that all fields are varchar2. This table is linked in an access database, and when I try to do an insert from a data aggregate query, it throws the error ‘can bind a LONG value only for insert into a LONG column’. If I try the same insert in sqlplus it works perfectly. If I try copy the row (Ctrl+C and Ctrl+V) without the field I think is incorrect, it inserts correctly, and then, if I type the same string trying to insert, don’t throw the error. Reading other posts, it seems it’s an encoding error, but I don’t know where can change it.

2
  • Is the resulting data in your access app greater than 4000 bytes?
    – Philᵀᴹ
    May 13, 2015 at 13:55
  • No, the field is a varchar2 with 10 chars long, and the data to insert is like " 12345" May 13, 2015 at 16:21

1 Answer 1

0

The problem was that all oracle linked tables in msaccess database, have the link description of an odbc of the previous database version (DBA=W;APA=T;EXC=F;FEN=T;QTO=F;). One of this parameters (Enable LOBs) was diferent and causes the error. To solve the problem have to relink all the tables of de msaccess database. It's important to relink all, because masccess make the connection to oracle for all the linked table in the first access of any table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.