 | |
#41
 
| |||
| |||
|
Re: ORA-01460 error -
10-22-2008
, 05:34 PM
|
Then what's the point of anyone ever posting anything at all on the web about oracle, including this newsgroup? I see your point in that oracle can update their docs whenever things change, but that does not mean other sites are not valuable resources as well. Explain to me what is wrong with the information on the posted site, especially as it relates to this thread (this is rhetorical). |
Oracle 7 was released in 1994.
The abstract was simplified, and it failed you to distinguish between
native integers and non-native integers.
As sqlloader files are often cross-platform, native integers do NOT
occur at all (I have never seen them in almost 20 years of Oracle).
As far as I recall the original docs stress this issue much more as
this simplified version does.
The Oracle docs are often quite dense, and you need to read them very
carefully. An abstract may omit crucial information. This abstract
did, IMO.
--
Sybrand Bakker
Senior Oracle DBA
#42
| |||
| |||
|
|
On Oct 22, 10:13*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: On Oct 22, 2:08*pm, "Vladimir M. Zakharychev" vladimir.zakharyc... (AT) gmail (DOT) com> wrote: On Oct 22, 9:36*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: I'm trying to load images into an Oracle table using this technique: http://www.dba-oracle.com/oracle_new...p_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). It seems that example has another error in it: since fields are terminated by ',' and there are three fields being loaded, file name field MUST also be terminated by a comma, that is, the data section should look like this: BEGINDATA 1,C:\John.gif, 2,C:\smith.gif, 3,C:\sandra.gif, This probably is the source of the ORA-1460. Regards, * *Vladimir M. Zakharychev * *N-Networks, makers of Dynamic PSP(tm) * *http://www.dynamicpsp.com |
which is actually causing the error. Not only INTEGER(5) is an
incorrect specification, because its length can only be a power of 2,
but the data itself is not binary, so no wonder Oracle has problems
converting it. I sometimes wonder why DB posts stuff on his sites
without any validation whatsoever...
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
#43
| |||
| |||
|
|
On Oct 22, 10:13*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: On Oct 22, 2:08*pm, "Vladimir M. Zakharychev" vladimir.zakharyc... (AT) gmail (DOT) com> wrote: On Oct 22, 9:36*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: I'm trying to load images into an Oracle table using this technique: http://www.dba-oracle.com/oracle_new...p_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). It seems that example has another error in it: since fields are terminated by ',' and there are three fields being loaded, file name field MUST also be terminated by a comma, that is, the data section should look like this: BEGINDATA 1,C:\John.gif, 2,C:\smith.gif, 3,C:\sandra.gif, This probably is the source of the ORA-1460. Regards, * *Vladimir M. Zakharychev * *N-Networks, makers of Dynamic PSP(tm) * *http://www.dynamicpsp.com |
which is actually causing the error. Not only INTEGER(5) is an
incorrect specification, because its length can only be a power of 2,
but the data itself is not binary, so no wonder Oracle has problems
converting it. I sometimes wonder why DB posts stuff on his sites
without any validation whatsoever...
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
#44
| |||
| |||
|
|
On Oct 22, 10:13*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: On Oct 22, 2:08*pm, "Vladimir M. Zakharychev" vladimir.zakharyc... (AT) gmail (DOT) com> wrote: On Oct 22, 9:36*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: I'm trying to load images into an Oracle table using this technique: http://www.dba-oracle.com/oracle_new...p_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). It seems that example has another error in it: since fields are terminated by ',' and there are three fields being loaded, file name field MUST also be terminated by a comma, that is, the data section should look like this: BEGINDATA 1,C:\John.gif, 2,C:\smith.gif, 3,C:\sandra.gif, This probably is the source of the ORA-1460. Regards, * *Vladimir M. Zakharychev * *N-Networks, makers of Dynamic PSP(tm) * *http://www.dynamicpsp.com |
which is actually causing the error. Not only INTEGER(5) is an
incorrect specification, because its length can only be a power of 2,
but the data itself is not binary, so no wonder Oracle has problems
converting it. I sometimes wonder why DB posts stuff on his sites
without any validation whatsoever...
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
#45
| |||
| |||
|
|
On Oct 22, 10:13*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: On Oct 22, 2:08*pm, "Vladimir M. Zakharychev" vladimir.zakharyc... (AT) gmail (DOT) com> wrote: On Oct 22, 9:36*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: On Oct 22, 1:35*pm, blindsey <blind... (AT) dsicdi (DOT) com> wrote: I'm trying to load images into an Oracle table using this technique: http://www.dba-oracle.com/oracle_new...p_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). It seems that example has another error in it: since fields are terminated by ',' and there are three fields being loaded, file name field MUST also be terminated by a comma, that is, the data section should look like this: BEGINDATA 1,C:\John.gif, 2,C:\smith.gif, 3,C:\sandra.gif, This probably is the source of the ORA-1460. Regards, * *Vladimir M. Zakharychev * *N-Networks, makers of Dynamic PSP(tm) * *http://www.dynamicpsp.com |
which is actually causing the error. Not only INTEGER(5) is an
incorrect specification, because its length can only be a power of 2,
but the data itself is not binary, so no wonder Oracle has problems
converting it. I sometimes wonder why DB posts stuff on his sites
without any validation whatsoever...
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.