Using Flyway and TOAD to compile the same Oracle code -

as company looking use flyway manage our oracle database migrations, , tool looks it'll excellent our needs. i've looked further how it'll fit our development processes , have run problem have not been able resolve.

we'll setting additional database instance we'll using continuous integration, , automated testing. we'll use flyway release our db application instance. allow multiple versions of database application we'd ability release our db code different schemas. so, if had schema called scott, may want release code scott_rm, scott_ci, scott_v5, etc.

we can manage in flyway using placeholders mimic syntax required variable substitution in oracle, i.e.

flyway.placeholderprefix=&& flyway.placeholdersuffix=. 

this works when running through flyway, or sql*plus. our package declaration this:

create or replace package &&schema_scott..pa_package 

however, problem lies when developer working within toad , want compile code directly own schema. when run script (f5), or run sql*plus variable flagged requiring value, allowing code compiled correct schema. however, when compiling code (f9) in toad variable isn’t recognised , receive oracle error “ora-04050: invalid or missing procedure, function, or package name”.

it’s not practical use f5 compile code, because when there compile error doesn’t jump offending line, happens when f9 pressed. e.g.

create or replace package &&schema_scott..pa_package    lv_num number();  -- compile error end; / 

interestingly looked oracle’s sql developer , found these variable substitutions work there i’d hope.

does know how might resolve problem in toad?