Stew Stryker
Member³
When I try to export my SQL results set that includes a CLOB in SQL format, I get the error message:
One or more columns are too long to export as SQL. The limit is 4000 bytes.
These CLOBS are text, just too long to store as VARCHAR2.
I understand that you can't just generate INSERT statements for these, as the INSERT limits the length. At least for text CLOBs, I think you could insert part, then update that row with the remaining part(s). I've used that technique before, but it's been table-specific.
Could you please add this to the enhancements list?
Thanks,
Stew
One or more columns are too long to export as SQL. The limit is 4000 bytes.
These CLOBS are text, just too long to store as VARCHAR2.
I understand that you can't just generate INSERT statements for these, as the INSERT limits the length. At least for text CLOBs, I think you could insert part, then update that row with the remaining part(s). I've used that technique before, but it's been table-specific.
Could you please add this to the enhancements list?
Thanks,
Stew
