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: Friday, February 16, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L
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 to get some remote
data into an 8.1.7 NT install and running into trouble with CLOBS. Ideally
I need to do an
INSERT INTO TABLE2
SELECT CLOB1, CLOB2, VARCHAR2)
Is this possible? I am getting an error that looks a lot like this is not
an acceptable LONG operation.
thanks for any advice.
adam
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adam Turner
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gary Weber
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adam Turner
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
