My Oracle Support Banner

Substitution Variables Using Special Characters (ie. Underscore and Period) Not Getting Parsed Correctly (Doc ID 961774.1)

Last updated on JANUARY 31, 2022

Applies to:

SQL*Plus - Version to [Release Oracle10g to 11.1]
Information in this document applies to any platform.


The resulting output filename does not parse correctly when using substitution variables that pass or contain special characters such as:  underscore ( _ ) or the period (.).

-- Steps to Reproduce

1. Run the below example script:
C:\>sqlplus /nolog @D:\control\sql\DbName_DateTime.sql 'TEMPDB'


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.