Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem with a big APEX scripts #46

Open
AndreyBerliner opened this issue Feb 28, 2023 · 1 comment
Open

Problem with a big APEX scripts #46

AndreyBerliner opened this issue Feb 28, 2023 · 1 comment

Comments

@AndreyBerliner
Copy link

AndreyBerliner commented Feb 28, 2023

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
Copy link
Author

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant