"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 12.2.0.1 and laterInformation 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":
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
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 |