PL/SQL (MOSC)

MOSC Banner

Database to CSV - embedded CRLF

edited Oct 17, 2013 10:19AM in PL/SQL (MOSC) 2 commentsAnswered
I am using the procedure below to write a csv file using output of a query.  The problem is that one of the columns in the table contains CRLF in the data and this creates extra records in my output.  How can I tell UTL_FILE.put to ingore the CRLF in the data and only act on UTL_FILE.new_line?  Thanks.


PROCEDURE PDUMP_CSV
(
   I_query IN VARCHAR2
 , I_dir IN VARCHAR2
 , I_filename IN VARCHAR2
 , I_separator IN VARCHAR2
 , I_headers IN BOOLEAN DEFAULT FALSE
 , I_trailing_separator IN BOOLEAN DEFAULT FALSE
 , I_max_linesize IN NUMBER DEFAULT 32000

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center