CODEWITHSUNDEEP
oracle-databasestored-proceduresplsql
user2467077
user2467077

Reputation: 23

How to compile multiple stored procedures from a single file?

With .sql, you can run queries from multiple .sql files using language like this: @query.sql

How can you do the same with Oracle? I'd like to compile 5 stored procedures from 5 different files using a sixth file to source the 5 procedures.

Thanks!

Upvotes: 0

Views: 1396

Answers (1)

the_slk
the_slk

Reputation: 2182

@/path/main_script.sql:
START script_one.sql
START script_two.sql
START script_three.sql
START script_four.sql
START script_five.sql

OR

@/path/main_script.sql:
@@/path/script_one.sql
@@/path/script_two.sql
@@/path/script_three.sql
@@/path/script_four.sql
@@/path/script_five.sql

Upvotes: 3

Related Questions