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?
Tagged:

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file