Yes, Tom has a good breakdown here
And I have sample page that demonstrates techniques, check top of page source
In regard to you not being allowed to create PL/SQL in the database - that is extremely restrictive for an APEX application, which is basically PL/SQL itself. It will impact performance and maintainability, and there has been a recent discussion here
But I am not sure any of this helps me.
On the other hand, let's assume that calling by jscript an application process works for me... problem is, this application process has a very very very lengthy amount of chars, of the sort htp.p( ) to build up a set of tables there. I mean, the return from that htp.p is REALLY big. How can I put that info, inside a <div id="my_div"> <div> section? Because I am not sure on how to do that... would a simple getElementById("my_div").innerHTML work? I mean, is very very big the string genereated through the htp.p (and I know because I still need to set a some sort of pagination because it won't ever be able to do it for the full length of the information I have)...
Finally, I agree, not having an access to build up my pl/sql code is very restrictive (and would be the best solution to my dilema), but I am not the DBA and I have already asked... so, can't do anything else about. it.
These PL/SQL processes can be on demand processes defined as an Application Process or an AJAX Callback within the page.
I would ask for the reasons behind not being able to compile packages. Seems extremely inhibitive for an Oracle application and the DBA should know better.
I got it to work. But still have one issue.
In the APPLICATION PROCESS, I have a code like:
: PXX_ITEM := 3;
In the middle of al the "htp.p()" coding there.
Problem is, I cannot find a way to return that value of : PXX_ITEM, since it seems though I can use it in the application process, it won't change it.
I am having an issue...
Have to create a dynamic report, very specific, which means I have to manually draw it by using html... (templates won't work because of the characteristics of this report).
That's a challenge. Please explain why a standard report and templates "won't work". That is very rare in my experience.
Now, I am facing 2 problems...
1- I am not being allowd to create a proc/pkg/table/etc (any object) in the referenced DB schema (nor other that can communicate with it).
That's not a challenge, it's a stupid restriction. Why this is the case? How does whoever is responsible justify it? Would they tell a Java developer that they couldn't create classes?