Several things. One, you can indicate (RTFM, don't remember the details) that your physical record is terminated by something else than a carriage return. Second, if what you want to store is PL/SQL code, then carriage returns are useless - they are 'for your eyes only' (which is why you have a hardly readable but Oracle-usable V$SQLTEXT and a V$SQLTEXT_WITH_NEW_LINES when having an indiscreet peek into the SGA). Third, if I were you I would use either CLOBs or even VARCHAR2 rather than LONGs. Fourth, you look on your way to build the application of death and reinventing the stored procedure. There are times when flexibility is not THAT desirable. I am not sure that EXECUTE IMMEDIATE of dynamically built PL/SQL blocks (if I read correctly between the lines) is a good solution.
>----- Original Message ----- >From: "Kanchanakuntla, Suhasini" ><[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Tue, 30 Apr 2002 07:08:51 > >Hi all, > >I need to insert special charecter into the >database through sql loader. >i.e., I have a table with LONG datatype field and >data should read: >[Cancellation] > IF ServiceDate = sysdate THEN > Chargepercent(100) > ELSEIF ServiceDate > sydate THEN > chargepercent(50) > ELSE > chargepercent(25) > ENDIF >My flat file: > '[Cancellation' ||chr(13)||chr(10)|| 'IF >ServiceDate = sydate THEN ' >||chr(13)||chr(10)|| 'Chargeperce(100)' >||chr(13)||chr(10)|| > 'ELSEIF ServiceDate > sysdate THEN ' >||chr(13)||chr(10)|| >'chargepercent(50)' ||chr(13)||chr(10)|| 'ELSE ' >||chr(13)||chr(10)|| > 'chargepercent(25)' ||chr(13)||chr(10)|| >'ENDIF' > >When I use the above flat file to load the table >with sqlldr the table is >not getting populated the way I expected. How can >I insert the new lines? > >Thanks, >Suhasini. > >-- >Please see the official ORACLE-L FAQ: >http://www.orafaq.com >-- >Author: Kanchanakuntla, Suhasini > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 >FAX: (858) 538-5051 >San Diego, California -- Public Internet >access / Mailing Lists >To REMOVE yourself from this mailing list, send an >E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of >'ListGuru') and in >the message BODY, include a line containing: UNSUB >ORACLE-L >(or the name of mailing list you want to be removed >from). You may >also send the HELP command for other information >(like subscribing). >--------------------------------------------------- >----------------- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
