Richard Crawford wrote:
> I have come to understand that Oracle hates me with a passion
> bordering on the psychotic. What I don't understand is why.
>
> The neverending quest to migrate from MS-SQL Server to Oracle has been
> dealt another blow. One of the tables I have in the SS7 database has
> three fields defined as TEXT. At first I tried to migrate these to
> CLOB fields in Oracle, but that failed for no reason I could figure
> out. I decided that since none of the fields in this table had more
> than 4000 characters, I would migrate them from TEXT to VARCHAR2(4000).
>
> When I tried exporting data from SS7 to Oracle this time, I get the
> following error:
>
> Ora-01461: can bind a LONG value only for insert into a LONG column
>
> which makes no sense at all to me because there no columns of type LONG.
>
> What am I doing wrong? I have Googled until my fingers bleed to no
> avail. I have double-checked my /etc/system file and it is fine.
>
> The system is question is ORacle 9i on a Solaris 9 box.
>
It would be remarkably more helpful if you gave anyone an indication of
what methodology you are using to accomplish this
seemingly facile task. I'd suggest using SQL*Loader. Alternatively post
details and your code. We have no ability to guess
at what you are doing. Well actually we can guess but our guesses would
likely be irrelevant.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Oct 08 2003 - 01:19:44 CDT
