Recent content by kevina555

Hi All, I have a Normalization situation. I have denormalized data in the incoming flat file and has to be normalized into the target, while generating PK as well. But SQL Loader only allows us to create a sequence. Can I use a trigger to tell SQL Loader that if (field x in the record just...

Hi LKBrwnDBA, I've written a before insert trigger, but something seems to be wrong wit this, 'coz I get the PLS 00103 error everytime I try to run this. CREATE OR REPLACE TRIGGER IDMAP BEFORE INSERT ON fcBalances FOR EACH ROW BEGIN IF :NEW.ACCOUNTID = 11777 THEN...

Hi LKBrwnDBA, Thank you for the clarification. I was hoping this would be possible. But the problem now is that I have a list of about 50 values to be decoded (into 50 others obviously) and when I give all these 100 in the proper format, I receive the SQLLDR 350 error which says that the 'max...

Hi, I need to decode an incoming value from the delimited file and insert the decoded value into the target table. For this, I was wondering if I could write a "decode" in the control file itself or if I have to use a Before Insert Row level trigger........ Thank you.

Hi Mufasa, I apologize, this is my first time here and don't know the customs. Thank for the suggestion. I followed it. LKBrwnDBA, Thank you for the great help.....Many tahnks with all my heart(I donno about the stars and all, but you very well deserve a real one). You are a lifesaver...

Hi LKBrwnDBA, KUDOS TO YOU!!!!! Although your solution did not work for me, it did trigger a thought (declaring the sequence at the end of the regular INFILE fields and giving a filler in its original place) and it worked splendid. Although I said that I followed all your suggestions, I...

Hi LkBrwnDBA, Thank you for your suggestions. I have followed all in writing the control files. But still.....I think I'm out of luck on this.....Thanks anyways. I really appreciate all your effort. Thank you

I'm extremely sorry for not mentioning this in the same message, but the INFILE I sent you appears only 5 fields because I sent you only the ones surrounding STMTDATE. Here's my ugly scenario: In fact, there are a total of 41 fields in the INFILE that need to be transferred to 9 different...

When I look at the DB through TOAD, I get "MM/DD/YYYY hh24:mi:ss" When I query the same Db through SQLPlus, I get "DD-MON-YY" format results. Now, I understand that the DB has a default format of DD-MON-YY for any column declared as a DATE variable, but I seem to be too confused with this...

Thank you for the info.....I did not have any value under the nls_lang parameter box in the registry for hkey\localmachine\software\oracle so, I added AMERICAN_AMERICA.WEISO8859P1 as the value. Also, the nls_lang value for hkey\localmachine\software\oracle\homeo had a different value. I...

Hi LKBrwnDBA, I have already posted my control file. Anyways, here it is again..... LOAD DATA INFILE 'c:\ARKfeed0225.txt' BADFILE 'c:\ARKfeedStmt0224.bad' DISCARDFILE 'c:\ARKfeedStmt0224.dsc' APPEND INTO TABLE fcSTATEMENTS FIELDS TERMINATED BY "~"...

Hi LkBrwnDBA, Thank you for the suggestion. I really appreciate the response. I have tried using the TimeStamp definition previously and even now, after your suggestion. I get the error Record 1: Rejected - Error on table FCSTATEMENTS, column STMTDATE. ORA-01843: not a valid month even...

Hi All, I'm a new subscriber to this forum, but have been a great admirer and regular visitor. Very Informative. I've now run into a problem while using SQL Loader. I've used this in the past, but never had suchan irritating issue. I'm trying to load a delimited file into Oracle using...