SP2-0310 Error when Calling a SQL Script in Another Script using @@ and the Path to the Parent Script Contains Spaces (Doc ID 745780.1)

Last updated on JULY 18, 2021

Applies to:

Symptoms

Given two sql scripts, main_script.sql and script1.sql.

script1.sql is called within main_script.sql using the @@ notation in order to inherit the path used to call main_script.sql.

If the path provided to main_script.sql contains spaces, main_script.sql executes successfully, but script1.sql will fail to execute throwing:

An exemplification of the issue:

Cause

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