From previous discussion on profox list, I got the idea that SPT (via sqlexec()) won't work against very long SQL statement. So, I have to use remote views for that. Before using LONG, I've tried to use varchar2(4000), but it can save only max 2000 chars (+/-). Above 2000 chars, the VFP returns error ('Invalid precission', I think...)

Then I turned into LONG. But from manual, I understand that CLOB should be the one I've to choose. I can append a long chars into the remote views without error, but in reality only part of strings (approx 70 chars or so) that can be saved into ORACLE. I have no idea why only small part of the string that is written into the ORACLE. I don't know which part of the system (VFP, ODBC, ORACLE) that makes the trouble. Any idea?

Regards,