Re: ORA-01460 error
Date: Wed, 22 Oct 2008 11:13:11 -0700 (PDT)
Message-ID: <00f9ebd8-b42d-4fe4-acb6-baa65f02e5db@8g2000hse.googlegroups.com>
On Oct 22, 2:08 pm, "Vladimir M. Zakharychev"
<vladimir.zakharyc..._at_gmail.com> wrote:
> On Oct 22, 9:36 pm, blindsey <blind..._at_dsicdi.com> wrote:
>
> > On Oct 22, 1:35 pm, blindsey <blind..._at_dsicdi.com> wrote:
>
> > > I'm trying to load images into an Oracle table using this technique:
>
> > >http://www.dba-oracle.com/oracle_news/2005_5_11_easy_top_loading_imag...
>
> > > SQLLDR is kicking back all rows with the error "ORA-01460:
> > > unimplemented or unreasonable conversion requested."
>
> > > Any ideas? How to get around/fix?
>
> > It's Oracle 10.2.0.1.0, by the way.
>
> And your table DDL and SQL*Loader control file are...?
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Exactly as in the linked example, except for the filenames, which are jpgs instead of gifs. (and changing the second "file_id" to "file_data", which is an obvious error). Received on Wed Oct 22 2008 - 13:13:11 CDT