Here are some considerations for SQL File format and deployment.
You will need to end file / if it contains Package Specification, Package Body, Trigger.
CREATE OR REPLACE PACKAGE xxhr_bipub_rep_pkg AS PROCEDURE generate_xml(p_errbuf OUT VARCHAR2 ,p_retcode OUT NUMBER); END xxhr_bipub_rep_pkg; /
- Consider adding compileInvalidSqls operation in Deploy workflow if SQL files are being deployed. This operation can take longer if there are many invalid objects in Schema.