OraFAQ Forum: Server Utilities » SQL Loader When Clause

Home » RDBMS Server » Server Utilities » SQL Loader When Clause

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

SQL Loader When Clause [message #73857]

Mon, 26 July 2004 04:17

Suresh N
Messages: 7
Registered: March 2003

Junior Member

Hi,

When I use when Clause in Control file like following.

WHEN !='USER' the values is getting converted into some hexadecimal values and all the recods discarded.

Can u pls provide a solution.

Thanks in Advance,

Suresh

Report message to a moderator

Re: SQL Loader When Clause [message #73890 is a reply to message #73857]

Thu, 29 July 2004 07:44

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

Looks like a syntax error to me:

WHEN ???? !='USER'

The following would be valid:

WHEN (5) != 'USER' 
WHEN field5 != 'USER'
Etc.

Best regards.

Frank

Report message to a moderator

Previous Topic:	Help converting excel spreadsheet into csv and loading in SQLLDR
Next Topic:	ORA - 12203 TNS Unable to Connect Destination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:12:11 CDT 2024