 | |
#1
 
| |||
| |||
|
SQLLDR problem -
07-16-2008
, 03:51 PM
#2
| |||
| |||
|
|
I'm trying to import a fixed-length ASCII file using SQLLDR. The end-of-line is 0D 0A, as usual. But some notes fields in the data use 0D 0D 0A within them. SQLLDR interprets this as end-of-line. Is there a way I can tell SQLLDR to ignore that sequence or translate it into something else (like a space)? |
http://download.oracle.com/docs/cd/B....htm#sthref472
Best regards
Maxim
#3
| |||
| |||
|
|
I'm trying to import a fixed-length ASCII file using SQLLDR. The end-of-line is 0D 0A, as usual. But some notes fields in the data use 0D 0D 0A within them. SQLLDR interprets this as end-of-line. Is there a way I can tell SQLLDR to ignore that sequence or translate it into something else (like a space)? |
http://download.oracle.com/docs/cd/B....htm#sthref472
Best regards
Maxim
#4
| |||
| |||
|
|
I'm trying to import a fixed-length ASCII file using SQLLDR. The end-of-line is 0D 0A, as usual. But some notes fields in the data use 0D 0D 0A within them. SQLLDR interprets this as end-of-line. Is there a way I can tell SQLLDR to ignore that sequence or translate it into something else (like a space)? |
http://download.oracle.com/docs/cd/B....htm#sthref472
Best regards
Maxim
#5
| |||
| |||
|
|
I'm trying to import a fixed-length ASCII file using SQLLDR. The end-of-line is 0D 0A, as usual. But some notes fields in the data use 0D 0D 0A within them. SQLLDR interprets this as end-of-line. Is there a way I can tell SQLLDR to ignore that sequence or translate it into something else (like a space)? |
http://download.oracle.com/docs/cd/B....htm#sthref472
Best regards
Maxim
#6
| |||
| |||
|
|
blindsey schrieb: I'm trying to import a fixed-length ASCII file using SQLLDR. The end-of-line is 0D 0A, as usual. |
Quote:
|
But some notes fields in the data use 0D 0D 0A within them. SQLLDR interprets this as end-of-line. Is there a way I can tell SQLLDR to ignore that sequence or translate it into something else (like a space)? Fixed record format? |
Yours,
Laurenz Albe
#7
| |||
| |||
|
|
blindsey schrieb: I'm trying to import a fixed-length ASCII file using SQLLDR. The end-of-line is 0D 0A, as usual. |
Quote:
|
But some notes fields in the data use 0D 0D 0A within them. SQLLDR interprets this as end-of-line. Is there a way I can tell SQLLDR to ignore that sequence or translate it into something else (like a space)? Fixed record format? |
Yours,
Laurenz Albe
#8
| |||
| |||
|
|
blindsey schrieb: I'm trying to import a fixed-length ASCII file using SQLLDR. The end-of-line is 0D 0A, as usual. |
Quote:
|
But some notes fields in the data use 0D 0D 0A within them. SQLLDR interprets this as end-of-line. Is there a way I can tell SQLLDR to ignore that sequence or translate it into something else (like a space)? Fixed record format? |
Yours,
Laurenz Albe
#9
| |||
| |||
|
|
blindsey schrieb: I'm trying to import a fixed-length ASCII file using SQLLDR. The end-of-line is 0D 0A, as usual. |
Quote:
|
But some notes fields in the data use 0D 0D 0A within them. SQLLDR interprets this as end-of-line. Is there a way I can tell SQLLDR to ignore that sequence or translate it into something else (like a space)? Fixed record format? |
Yours,
Laurenz Albe
 |
« 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.