Behaviour of SQL*Plus @@ command

deboiph

@) is used within a script file to execute another script file contained in the same directory@ functions exactly the same as @.

I have a file "V23.0__install.sql" whose content is the following:
@tables.sql
@indexes.sql
...

The "tables.sql" script is located in the same directory as the V23.0__install.sql" file.

However Flyway does not find it and stops with the following error: ERROR: Unable to parse statement in C:\Users\...\install\23.0\V23.0__install.sql at line 1 col 1. SP2-0310: unable to open file "tables.sql"

Caused by: SP2-0310: unable to open file "tables.sql"

@ correctly?

Victoria W

Hi @deboiph

We have confirmed the behavior and have an issue open on our development backlog for this.

We'll update this post when we have further information.