RE: How to insert new lines through SQLLDR

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Tue, 30 Apr 2002 08:15:18 -0800
Message-ID: <F001.00453774.20020430081518@fatcity.com>

('binary' encoding is not supported, stored as-is)
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"
><skanchanakuntla_at_loralskynet.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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: skanchanakuntla_at_loralskynet.com
>
>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: ListGuru_at_fatcity.com (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: sfaroult_at_oriolecorp.com

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: ListGuru_at_fatcity.com (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).

Received on Tue Apr 30 2002 - 11:15:18 CDT