oracle-db-tools
oracle-db-tools copied to clipboard
Problem with a big APEX scripts
Hi! I tried to implement in my Application both of the Methods described in the link below.
https://github.com/oracle/oracle-db-tools/blob/d7c8b9d5ff10033bbf2e8750e87046ace834160a/sqlcl/java/src/ParseScriptRunOneAtATime.java https://github.com/oracle/oracle-db-tools/blob/d7c8b9d5ff10033bbf2e8750e87046ace834160a/sqlcl/java/src/RunMyScript.java
There is a problem in both of them for Big SQL Scripts, my script is 6,5 Mb big it's APEX Application script. I tried both of the APEX Types of Scripts splitted and not splitted it's executing only half of the script in just break in the middle without errors. But only half of the script was executed.
Can someone tell me where there is a problem hier?
PS. It's not a problem that Script is too big, i assuming that this Java bibliotheque can't be used for import APEX Application.
Another update, i'm not able to load any Apex App if script user_interfaces.sql contains record
p_global_page_id=>0
I tried out in different Apex Versions 20.1, 21.1, 22.1, it goes to this script and just stops execution without errors. As a result no Pages was loaded, only components, so half pf Application was not loaded. But if I remove this line, it works without problems with any Apex Version.
So there is some Parameter missing for Version compatibility. Or may be another reason. What could be a Problem?