How can we help you today? How can we help you today?

Behaviour of SQL*Plus @@ command

@) 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?
Philippe Debois
0

Comments

1 comment

Sort by
  • Victoria W
    Hi @...

    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.
    Victoria W
    0

Add comment

Please sign in to leave a comment.