Repository navigation
Ability to use temporary Templates #23
Description
As I work on a template editor application, I find that I need to test the templates that I am creating from within the application.
Because the templates are incomplete, the templates should not be part of the TE_TEMPLATES table.
All templates being edited by application would need to be accessed by the tePLSQL engine. As such, all the templates would need to be pushed to the DB Server. They don't need to reside there across tePLSQL calls.
Should this enhancement be developed?
If so, which method should be used?
- option 1 - use a GTT.
- option 2 - use an associative array within the Package.
I'm leaning towards Option 2.
Thanks,
MK
Activity
MikeKutz commentedon Dec 10, 2017
The implementation of #29 suggests that the temporary templates can be part of the
p_varsparameter forrenderandprocess. The template code will need to be limited to 32767 bytes each.A new internal variable would need to be created so that one can choose to retrieve the template code from the table
TE_TEMPLATESor the associative arrayp_vars.MikeKutz commentedon Aug 17, 2020
To support #34 , I was thinking about using a Private Temporary Table (PTT).
Cons
Pros
jgebal commentedon Aug 17, 2020
Would GTT suffice? That way you don't need 19c to use it.
MikeKutz commentedon Aug 17, 2020
I'm still deciding between GTT and PTT.
Since the package is Invoker's Rights, a PTT appears to have a slight advantage over GTT.
The advantage of a PTT: The PTT ,that the Invoker creates, will disappear at the end of a transaction/session.
Most likely, I'll start with a GTT, possibly make PTT as a runtime option.