Home » RDBMS Server » Server Utilities » Import Error 297
icon5.gif  Import Error 297 [message #184142] Tue, 25 July 2006 09:09 Go to next message
fuchsst
Messages: 5
Registered: July 2006
Junior Member
Hello,

hopefully anyone can help me. I recieve the folowing message on trying to load a textfile using the sql-loader:

SQL*Loader-297: Ung³ltige Syntax oder Bindevariable in SQL-Folge f³r Spalte "TEST".
ORA-01756: Anf³hrungsstrich fehlt bei Zeichenfolge


(In English it would something like:
SQL*Loader-297: Invalid syntax or bindvariable in SQL-Statement for column "TEST"
ORA-01756: Quoted string not properly terminated)

We played around with different testfiles and results showed that it is only a problem with textfields (as the second message supposes).
The problem is that the same ctl file and the same client version on another PC works fine, so it seems to be a configuaration problem. Does anyone has an idea what may be the difference and where i can find it?

Thanks in advance...
Re: Import Error 297 [message #184146 is a reply to message #184142] Tue, 25 July 2006 09:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Could you please post the concerned text file and the ctl file?
Re: Import Error 297 [message #184329 is a reply to message #184146] Wed, 26 July 2006 03:18 Go to previous messageGo to next message
fuchsst
Messages: 5
Registered: July 2006
Junior Member
attached the simple testfile
it works on a colleagues desktop but not on mine...
  • Attachment: Test.CTL
    (Size: 0.20KB, Downloaded 317 times)

[Updated on: Wed, 26 July 2006 03:21]

Report message to a moderator

Re: Import Error 297 [message #184331 is a reply to message #184142] Wed, 26 July 2006 03:21 Go to previous messageGo to next message
fuchsst
Messages: 5
Registered: July 2006
Junior Member
No Message Body
  • Attachment: test.txt
    (Size: 0.05KB, Downloaded 272 times)
Re: Import Error 297 [message #184372 is a reply to message #184331] Wed, 26 July 2006 06:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Works good for me too (9.2.0.4, Sun8, Sunblade100).
In your case, are the OS/Oracle version different in those machines?
Re: Import Error 297 [message #184390 is a reply to message #184372] Wed, 26 July 2006 07:06 Go to previous messageGo to next message
fuchsst
Messages: 5
Registered: July 2006
Junior Member
there are no fundamental differences both are win2k with oracle10g-client.
any idea where or what may be configured differently on the oracle client?
Re: Import Error 297 [message #184410 is a reply to message #184390] Wed, 26 July 2006 08:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There are a few known bugs in 10gR2 that are very unhappy with sqlldr.
Could you try something like this?
LOAD DATA
  INFILE  'test.data'
  Append
INTO TABLE test
  REENABLE DISABLED_CONSTRAINTS
  WHEN (1) = '5'
  (   
  TEST POSITION (2:10) "trim(:TEST)||'(RX)' "
  )  
Re: Import Error 297 [message #184444 is a reply to message #184410] Wed, 26 July 2006 10:07 Go to previous messageGo to next message
fuchsst
Messages: 5
Registered: July 2006
Junior Member
quite curious...

i changed the testfile and it worked...thanks
do you know or guess what was the wrong position? or is there a list of known problems with sqlldr/10gR2?
Re: Import Error 297 [message #184449 is a reply to message #184444] Wed, 26 July 2006 10:16 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The way the character strings are treated.
>>is there a list of known problems with sqlldr/10gR2?
That would be cool.
Check metalink.
Previous Topic: import problem with oracle 10.1.0 on Win2K
Next Topic: SQL * Loader issue
Goto Forum:
  


Current Time: Tue Dec 06 16:29:55 CST 2016

Total time taken to generate the page: 0.18038 seconds