Hi. I'm trying to exctract a table containing a CLOB column and save it into a CSV file. I was able to extract the CLOB column but I encountered a problem. Instead of giving me a single line for every row of data, the CSV file contains multiple lines per row of data. If I remove the CLOB column, the result shows a single line for every row of data. How can I solve this problem? Below is the sample of my SQL code:

SET LINESIZE 32000;

SET NEWPAGE 0;
SET SPACE 0;
SET PAGESIZE 0;
SET LONG 32000;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET TERMOUT OFF;
SET VERIFY OFF;
SET TRIMSPOOL ON;

SELECT NVL(ID, ' ') || '|' ||
NVL(AGTFLAG, 0) || '|' ||
NVL(ATTEMPTS, 0) || '|' ||
NVL(DTVALID, SYSDATE) || '|' ||
NVL(FNAME, ' ') || '|' ||
NVL(CODE, ' ') || '|' ||
NVL(LSTLOGIN, SYSDATE) || '|' ||
NVL(LNAME, ' ') || '|' ||
NVL(LSTPWRDUPDT, SYSDATE) || '|' ||
NVL(LSTPDTE, SYSDATE) || '|' ||
NVL(LGNFLAG, 0) || '|' ||
NVL(MNTNDBY, ' ') || '|' ||
NVL(MNAME, ' ') || '|' ||
NVL(PWRD, ' ') || '|' ||
NVL(ID, ' ') || '|' ||
NVL(REMARKS, ' ') || '|' ||
NVL(SESSION, ' ') || '|' ||
NVL(STAT, ' ') || '|' ||
NVL(TTLATTEMPTS, 0) || '|' ||
NVL(CREATIONDTE, SYSDATE) || '|' ||
NVL(BACKUPID, 0) || '|' ||
NVL(AUTHORIZATIONLMT, 0) || '|' ||
NVL(PWSOURCE, ' ') || '|' ||
NVL(SUBSTR(PWCERTIFICATE, 1, DBMS_LOB.GETLENGTH(PWCERTIFICATE) - 1), ' ') || '|' ||
NVL(EMAILADD, ' ') || '|'
FROM USER
WHERE CODE = '&1';

This is the sample result that I'm getting

120005|0|10|10-OCT-13|Kat|100001|12-DEC-13|Doedo|26-NOV-13|2
6-NOV-13|0| |D|password123|JASON_GALLARD
O_01| | |US04|10|10-OCT-13|0|0|MINIKEY|M
IICLjCCAZegAwIBAgIEN18U6zANBgkqhkiG9w0BA
QQFADBSMScwJQYDVQQEEx5CYW5rX29mX3RoZV9Qa
GlsaXBwaW5lX0lzbGFuZHMxJzAlBgNVBAMTHkJhb
mtfb2ZfdGhlX1BoaWxpcHBpbmVfSXNsYW5kczAeF
w0wNzA3MjMwNTIzMTRaFw0xNzA3MjQwNTIzMTRaM
GUxCzAJBgNVBAYTAlBIMQwwCgYDVQQKEwNCUEkxD
jAMBgNVBAsTBUZJUlMzMRwwGgYDVQQEExNKQVNPT
l9HQUxMQVJET19URVNUMRowGAYDVQQDExFKQVNPT
l9HQUxMQVJET18wMTCBnzANBgkqhkiG9w0BAQEFA
AOBjQAwgYkCgYEAp2ODdoLfZkEqZ7G02kGB4E38s
fls3PRGduBrwLjFHx/FnLNRajqXoljM3IPTZ/7ig
JABLH9XagZ+6pAwNr/ngebpmt5oz3lxwT4XZqCw6
yng04bYqXIvIbQJy9PtqDb/Ie9YDyO90J0xusNxt
QqxxD3ANjphwUQpzZbJmL2uZykCAwEAATANBgkqh
kiG9w0BAQQFAAOBgQAMxeMDzM7i0IihWjvE5xai/
rV5nrpQ6j3qjesG3bIPsuxctq0L2OEWyy2wg5lXX
fxcxvPxArhky5B4XPLor7suxNm+0hMYFh1tHkgvy
RHyVlHnY+d5ukzUUgxOubAv9V8ns0SaDwMDwHhXj
cQdW1jiGF4u9hdnFWwcERlvHcufpQ==
| |


Thanks in advance!