APEX

Hello,

I am getting the following error when I insert a row into a table:

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

The SQL I use to insert the record is:

insert into depot_master_customer
(depot, cust_id, name, add_line_1, add_line_2, town, county, postcode_out, postcode_in, last_updated)
values
('994', :p7_cust_id, '1', '1', '1', '1', '1', '1', '1', to_date(:p7_last_updated));

The problem is with the 'cust_id' column. This is a 'VarChar2' type column with length of 6. The value I am trying to insert from :p7_cust_id (which is a text field) is '999999'.

I have tried substituting the :p7_cust_id with the string '999999' in the above SQL and the insert works fine then.

Any ideas why I am getting this error, it's driving me mad! Any help appreciated as this has become quite urgent.

Thanks