This content has been marked as final. Show 4 replies
I have reviews the documentation you have pointed me to but i did not find any information about the internals of APEX.
I'm interested on how APEX internally manages to process SQL Scripts that is initially located on a client with SQL*Plus from PL/SQL.
Why exactly? It works like a black box.. Sometimes it is better to let it be then question why it works the way it does..
On the road of life...There are 'windshields', and there are 'bugs'
If this question is answered, please mark the thread as closed and assign points where earned..
The why is as follows:
We had to implement a very similar process for our own installation process and it would be most interesting to understand how Oracle solved this problem in Oracle.
I know quite a few people that implemented server based SQL Script processing from PL/SQL in many different ways (Java, Scheduler, pipes, etc.) and all of the solutions are quite complicated, so I would find it useful to see how APEX has solved this common problem.
This is not about changing the APEX installation process but rather on how to learn from APEX.