There is a little-used variant of DBMS_SQL.PARSE that allows you to store source code as a table of VARCHAR2 lines. It can be used to store SQL much larger than the 32,767 limit.

T-SQL code or is performed repetitively, stored procedures can be faster than batches of T-SQL code. During creation, stored procedures are parsed and optimized, and you can use an in-memory ...