oracle-db-tools icon indicating copy to clipboard operation
oracle-db-tools copied to clipboard

Problem with a big APEX scripts

Open AndreyBerliner opened this issue 1 year ago • 1 comments

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.

AndreyBerliner avatar Feb 28 '23 19:02 AndreyBerliner

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?

AndreyBerliner avatar Mar 08 '23 10:03 AndreyBerliner