OraFAQ Forum: Server Utilities » sqlldr caused error with 00h symbol in source file

Home » RDBMS Server » Server Utilities » sqlldr caused error with 00h symbol in source file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlldr caused error with 00h symbol in source file [message #475140]

Mon, 13 September 2010 05:02

dimas_xp
Messages: 4
Registered: September 2010
Location: MSK

Junior Member

I am loading data file, and in some positions there is symbol 00h. This is caused error of sqlldr and uploading stops.
How I can replace this symbol or do something else to fix this error.

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475142 is a reply to message #475140]

Mon, 13 September 2010 05:14

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As far as I know, you have to do it outside SQL*Loader as Oracle is written in C and for C a '\0' character is the end of a string.

Regards
Michel

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475147 is a reply to message #475142]

Mon, 13 September 2010 06:10

dimas_xp
Messages: 4
Registered: September 2010
Location: MSK

Junior Member

it's not a approach in my case. Source file shouldn't be changed. Is there any other ideas?

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475156 is a reply to message #475147]

Mon, 13 September 2010 06:33

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"This can't be done in SQL*Loader"
"Yes, but I want to do it in SQL*Loader"
"But this can't be done"
"Yes but I want to do it"
...

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475157 is a reply to message #475156]

Mon, 13 September 2010 06:34

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Source file shouldn't be changed.

Copy the source file into another one, modify and load the copy.

Regards
Michel

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475158 is a reply to message #475157]

Mon, 13 September 2010 06:40

dimas_xp
Messages: 4
Registered: September 2010
Location: MSK

Junior Member

Do you have any perl script to replace this symbol?

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475159 is a reply to message #475158]

Mon, 13 September 2010 06:43

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No. Can't you write such one?

Regards
Michel

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475172 is a reply to message #475159]

Mon, 13 September 2010 07:16

dimas_xp
Messages: 4
Registered: September 2010
Location: MSK

Junior Member

I can try.

Report message to a moderator

Previous Topic:	EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i
Next Topic:	EXP, EXPDP, IMP & IMPDP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 14:47:15 CST 2025