RE: working with CLOBS

2001-02-16 Thread Gary Weber
The data is coming from Access? Number of options are present. Spool to text file and load LOBs by reading from such file. Move to LONG columns, if possible, then use TO_LOB to move data into LOB fields. A long shot, but Oracle used to ship this thing called Migration Assistant for Access. Having

RE: working with CLOBS

2001-02-16 Thread Adam Turner
Thanks. That is what I am trying to do now the only problem I see is that this is over a linked DB to Access over HSODBC and it looks like the calls aren't supported. What about populating some variables then writing them to the CLOB's ... hmmm adam -Original Message- Sent: Frida

RE: working with CLOBS

2001-02-16 Thread Gary Weber
Adam, You will most likely need to use dbms_lob package. It has few nifty functions for dealing with lobs/clobs Gary -Original Message- Sent: Friday, February 16, 2001 2:11 PM To: Multiple recipients of list ORACLE-L Hi listers. I have a question on migrating some data. I am tryign