oracle package body doesn't execute embedded files

[jccady]

I have a package specification and then a package body. The package body is built current by executing the file in sqlplus which will use the package body as file references allowing for each procedure of the package to be kept in a distinct file. Compile fails because body for pkg after update is the literal file including the @proc1.sql.

Have I missed something that would allow me to build my packages in this manner?

---

• directory contents
  • spec.pks
  • body.pkb
  • proc1.sql
  • proc2.sql

create or replace package body pkg
as
    @proc1.sql
    @proc2.sql
end pkg;
/

┆Issue is synchronized with this Jira Bug by Unito

[Barathwaja]

Hey @jccady , wild guess can u rename ur .pks or .pkb to .sql and run ??