How to insert new lines through SQLLDR
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).
ORA-12547: TNS:lost contact at execution of svrmgrl/sqlplus
Hi all, We are running Oracle 8.1.5 on HP-UX 11.0. Recently we started getting an error 'ORA-12547: TNS:lost contact' whenever trying to connect to svrmgrl. No upgrades on the server, it was working fine before. I searched the metalink and tried everything (relinking). The listener starts/stops ok. Here is the output of svrmgrl execution: gamprime:[/pkg/app/oracle/product/8.1.5/bin]$ svrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. ORA-12547: TNS:lost contact SVRMGR connect internal Password: ORA-12547: TNS:lost contact SVRMGR exit Server Manager complete. gamprime:[/pkg/app/oracle/product/8.1.5/bin]$ TIA 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).