What's the size of CLOBs you're retrieving in one shot?

>
>Im tyring to retieve data from a table in oracle including fields of datatype CLOB (character Large Objects) but VFP will give an error saying that the .tmp file has a too large filesize. Inserting data into CLOB fields via VFP/ODBC won't give any problem, but retrieving will.
>
>Retrieving the same data in sqlplus of oracle won't give any problem at all.
>
>Is there somebody who had encountered this problem as well and if so, how can I resolve this problem?
>
>Please advise.
>
>Best Regards,
>
>Aldrich Arendsz