allow additional methods for retrieving raw template CLOB

[MikeKutz]

Currently, there are two methods for retrieving the raw template CLOB.

• pull from the te_templates table
• extract from database objects

Other methods should be allowed.

Technical requirement: It should be easy to incorporated new methods into the package.

Analysis: Refactoring of certain parts of the code is needed to meet technical requirement.

Implementation Recommendation:

• Each method for retreiving raw template CLOB should be implemented as its own function.
• A "control" function should be responsible for choosing which method to use.
• For ease of future enhancements, all functions should use the same PL/SQL Type as its primary parameter.
• Code for decoding the string of parameters found in an include() directive should be in its own function.(*)

(*)Support for JSON, if desired, can be easily implemented.

Please assign to me as my fork has already implemented this.

MK

[MikeKutz]

example of other methods

• CLOB is stored on a web server (eg http://github.com/ )
• CLOB is stored on the file system of the DB (accessed via BFILE)

MK