Yes. Add new temporary field to form, same as the one with long. Created a temporary table holding entryid and CLOB. Copy from the TxxxCxxxx table to the temporary table.
Update the form (SQL) with data from the temporary table. Deleted the original fields, added new one with the same id. SQL update to copy from the temporary field to the new field. It is not possible to convert from LONG to CLOB using the update stmt. Had to use insert. Getting errors when doing it Oracle way as the column contain more than 32k data. -- Jarl On 5/29/07, patrick zandi <[EMAIL PROTECTED]> wrote:
** Anyone out there know how to make a long raw into a clob (oracle Style) Version 10.2.0.3 --- And yes I still had some of those laying around from the 4.0 days. -- Patrick Zandi __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"