"O/S Message: No Such File or Directory" When Using "Set MARK CSV On" (Doc ID 2758894.1)

Last updated on MARCH 07, 2022

Applies to:

Symptoms

SQL*PLUS exits with the following message when using "set MARK CSV on" with "WHENEVER OSERROR EXIT":

This happens in a particular case when the column data character size is near the total column width.  It appears to defy the SQL*Plus limits of total row width 32,767 characters.

For Example:

Given a table (call it "case1") with column defined as varchar2(32767).

Following sample creates the table and populates column via loop with 32,767 characters row width, which will reproduce the problem.

Then it works.

It also works if you "set MARK CSV off".

This also reproduces on the Linux environment although no OS message is returned.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.