My Oracle Support Banner

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

Last updated on MARCH 10, 2021

Applies to:

SQL*Plus - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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

"O/S Message: No such file or directory"


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".

In summary, you encounter "O/S Message: No such file or directory" when using "set MARK CSV on" and column with  32765+ characters, but not with 32764 or less.  

This reproduces with newer versions of SQL*Plus, like 19.x.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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