Ang: RE: Sqlloader - important

2001-11-14 Thread Roland . Skoldblom
<[EMAIL PROTECTED] cc: ate.ny.us> Subject: RE: Sqlloader - important Sent by: [EMAIL PROTECTED] 11/13/2001 10:40 AM Please respond to ORACLE-L

RE: Sqlloader - important

2001-11-13 Thread DBarbour
MAIL PROTECTED] cc: ate.ny.us> Subject: RE: Sqlloader - important Sent by:

RE: Sqlloader - important

2001-11-13 Thread Mohan, Ross
:-) -Original Message- Sent: Tuesday, November 13, 2001 12:15 PM To: Multiple recipients of list ORACLE-L '98'!' contains too many quotes Just a question: Do you try a little bit to find error reasons yourself or just write an email on the spot? ;) Gints Plivna IT Sistçmas, Meríeïa 1

Re: Sqlloader - important

2001-11-13 Thread tday6
Count your number of single quotes ('). It should be an even number. Roland.Skoldb lom

Re: Sqlloader - important

2001-11-13 Thread DBarbour
You have mismatched quotes. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl

Re: Sqlloader - important

2001-11-13 Thread G . Plivna
'98'!' contains too many quotes Just a question: Do you try a little bit to find error reasons yourself or just write an email on the spot? ;) Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/

RE: Sqlloader - important

2001-11-13 Thread Paul . Parker
Roland, You are missing a comma and a quote. It should be (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)", not (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", See the difference? Paul -Original Message- Sent: Tuesday, November

RE: Sqlloader - important

2001-11-13 Thread Mercadante, Thomas F
You are missing a comma and another single quote: orig==> (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", new==> (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)", Hope this helps! :) Tom Mercadante Oracle Certified Professional -Origin

RE: Sqlloader - important

2001-11-13 Thread Robertson Lee - lerobe
Come on Roland, look at your code closely, especially in the area of the exclamation mark. This really is too easy (and I've given you a large hint !!). -Original Message- Sent: 13 November 2001 15:45 To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file gi

RE: Sqlloader - important

2001-11-13 Thread Ivan_Rivera
Title: RE: Sqlloader - important I think the problem lies in the fact your missing a comma and a single quote: "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)" shouldn't that be: "DECODE(:KAMPANJTYP_ID,'?','

RE: Sqlloader - important

2001-11-13 Thread Ball, Terry
(KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", ^^^ No comma seperating the '98' and the !' Should probably read: (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)", -Original Message- Sent: Tue