I am receiving the following error:
ODBC--update on a linked table failed.
[Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column (#1461)
I have tried playing with cDate(Form!Field1) and cStr(Form!Field2) to resolve this but I keep getting the same error. I have also tried hard coding my values in a query and loading them that way and I get the same error. This is the sql for my query where I am hard coding the values:
Expand|Select|Wrap|Line Numbers
- UPDATE TBL SET TBL.APCESOURCE = "TCISP", TBL.APCEDATEAPPROVED = #4/30/2013#
- WHERE (((TBL.CACMNTH)=9) AND ((TBL.CACYR)=2013) AND ((TBL.PROJECTID)="TC365500") AND ((TBL.SUBPROJECTID)="TC36550002"));
I am able to manually enter a date and text in these fields in the Oracle table so I don't think this is a premissions issue. Do you know how to resolve this?