SQL Language (MOSC)

MOSC Banner

Database 19.3 - Filename With Special Characters like "$" Generates SP2-332 Spooling it

edited Apr 30, 2020 6:48AM in SQL Language (MOSC) 17 commentsAnswered ✓

I want to use spool with sqlplus 19 and i obtain SP2-0332 when filename contain $, on WINDOWS server 2012R2

I try to use

<span class="kwd">set</span><span class="pln"> escchar </span><span class="pun">$</span>

but $ seem to not able to be escape now.

i obtain error

SP2-0306: Option non valide.

Syntaxe : SET ESCCHAR [OFF|@|?|%]

My Oracle Support document 761384.1 indicate an old bug in 10G.

Is this bug appeared again or is there a other way to do this?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center