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