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 07, 2022

Applies to:

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


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

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




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

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