wwv_flow_error unreachable on Oracle autonomous cloud

[ANDREAS-MARKUS]

I've managed to get pit and utl_text installed on the Oracle cloud, including the client installs. But now I'm stuck at utl_apex because of wwv_flow_error. On the cloud the admin user has no privileges to grant execute on the apex package. And I couldn't find another way around the public synonym. Seems they didn't mirror all add_error overloads from wwv_flow_error in wwv_flow_error_api. I'm not sure if that is a bug or by design. But is there a way to mitigate the error being handled in your package, in a way that doesn't need to go through this particular add_error?

[j-sieben]

Hi Andreas,

Thanks again for pointing me on this. I removed the dependency on WWV_FLOW_ERROR. It was a try to enable UTL_APEX to show errors within the right place of an Interactive Grid which turned out not not to work as expected anyway.

It should now be possible to install the utility without problems.

Best regards,

Jürgen

Am 26.11.2021 um 20:50 schrieb Andreas Markus Groenevelt @.***>:

I've managed to get pit and utl_text installed on the Oracle cloud, including the client installs. But now I'm stuck at utl_apex because of wwv_flow_error. On the cloud the admin user has no privileges to grant execute on the apex package. And I couldn't find another way around the public synonym. Seems they didn't mirror all add_error overloads from wwv_flow_error in wwv_flow_error_api. I'm not sure if that is a bug or by design. But is there a way to mitigate the error being handled in your package, in a way that doesn't need to go through this particular add_error?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/j-sieben/UTL_APEX/issues/1, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5J7YATSNORMK5NBUMD7ELUN7QIVANCNFSM5I3IRQAQ. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[ANDREAS-MARKUS]

Super! Thanx! I will continue the coming days with the utl_apex and the apex application on the cloud. I had to change/fix some issues in the install sets for pit and utl_text. How would you prefer to get those? I can state them all separately, or I could clone your git masters and present you with a pull request?

[j-sieben]

Hi Andreas,

I guess it will be easier for you to just send me all files. I will replace my local GitHub and compare the changes. Thanks for your effort!

Best regards,

Jürgen

Am 27.11.2021 um 11:32 schrieb Andreas Markus Groenevelt @.***>:

Super! Thanx! I will continue the coming days with the utl_apex and the apex application on the cloud. I had to change/fix some issues in the install sets for pit and utl_text. How would you prefer to get those? I can state them all separately, or I could clone your git masters and present you with a pull request?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/j-sieben/UTL_APEX/issues/1#issuecomment-980537585, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5J7YAEM46DL7GKQAYSJ6TUOCXTHANCNFSM5I3IRQAQ. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[ANDREAS-MARKUS]

Will do! 👍

[ANDREAS-MARKUS]

Just to let you know: I'm still working on the apex pit app installation. On the cloud ADB the sys user is off limits and the admin user does not have the apex_administrator_role, so the apex_application_install does not work. I have to refactor your code to switch the connection to the workspace user before the apex install occurs.

[j-sieben]

Hi Andreas,

actually, I’m working on this. I started by removing the requirement to have DBA grants for UTL_APEX. It is now possible to install this as the APEX user.

Problem with the install as the owner is twofold: First, it is impossible to grant any missing rights, so there has to be a script to check this upfront. Secondly, the script to install a client access needs to be split into two scripts, making it a bit unease to install: Script one grants the necessary object privileges, whereas script two creates synonyms.

Im looking into this right now but I’m very thankful to know about your findings as well. I managed to remove the PIT dependency of a globally access context, which has negligible impact on APEX. The context is used to allow for logging in an connection pool environment. But as PIT automatically follows the APEX log settings, it is not required to have a context with PIT. I’m busy abstracting this out and implement a strategy that uses the global context if it is available and works locally if no context is present.

Beste Grüße

Jürgen

Am 05.12.2021 um 13:22 schrieb Andreas Markus Groenevelt @.***>:

Just to let you know: I'm still working on the apex pit app installation. On the cloud ADB the sys user is off limits and the admin user does not have the apex_administrator_role, so the apex_application_install does not work. I have to refactor your code to switch the connection to the workspace user before the apex install occurs.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/j-sieben/UTL_APEX/issues/1#issuecomment-986220665, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5J7YBTDPERFPGPDCERK7DUPNKSFANCNFSM5I3IRQAQ. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[ANDREAS-MARKUS]

Sorry for the long silence. Me and my wife and daughter came down with Covid-19 the last two weeks. And as I'm the oldest - and the fattest - I got sick the most. However, all is fine now! I saw you changed a lot so I will first check out the current version. If I find issues still there I will let you know shortly.

[j-sieben]

Hi Andreas,

no, pleas wait with checking out the latest version. I’m still busy fixing the installation issues. I changed a lot, it will not be necessary anymore to have an administrative account for installation, given that all necessary grants are present. But I’m, not yet convinced that everything is fine, I just committed and pushed the intermediate status as I was lecturing all week. You may of course just download and check the status, but I’m afraid that it’s not yet bug free.

Best regards

Jürgen

Am 20.12.2021 um 15:32 schrieb Andreas Markus Groenevelt @.***>:

Sorry for the long silence. Me and my wife and daughter came down with Covid-19 the last two weeks. And as I'm the oldest - and the fattest - I got sick the most. However, all is fine now! I saw you changed a lot so I will first check out the current version. If I find issues still there I will let you know shortly.

— Reply to this email directly, view it on GitHub https://github.com/j-sieben/UTL_APEX/issues/1#issuecomment-997976721, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5J7YBXGJF6YGDMITQB4STUR447BANCNFSM5I3IRQAQ. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you commented.

[ANDREAS-MARKUS]

All right, I'll tread carefully :-)

[j-sieben]

Hi Andreas,

installation scripts should now be stable again. I changed the approach to a bat/hs based approach but this way, you don’t need DBA roles anymore.

Best regards

Jürgen

Am 21.12.2021 um 08:41 schrieb Andreas Markus Groenevelt @.***>:

All right, I'll tread carefully :-)

— Reply to this email directly, view it on GitHub https://github.com/j-sieben/UTL_APEX/issues/1#issuecomment-998543730, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5J7YESG4S6FVMGUS5R3FTUSAVRVANCNFSM5I3IRQAQ. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you commented.

[ANDREAS-MARKUS]

Hello Jürgen,

I succeeded in installing PIT & UTL_TEXT & UTL_APEX & the Apex management app on the Oracle cloud environment! :-) I had to make some adjustments/correct some typo's etc. If I send the zipped codebases to you via j.sieben@condes.de, would that suit you? Or should I clone your GIT and push a branch? I have based it on your current versions at 13-04-2022 Just let me know.

[j-sieben]

Hi Andreas,

congratulation! Just send me your ZIP and I will look through your changes. Thanks very much for your support!

Best regards,

Jürgen

Am 13.04.2022 um 14:00 schrieb Andreas Markus Groenevelt @.***>:

Hello Jürgen,

I succeeded in installing PIT & UTL_TEXT & UTL_APEX & the Apex management app on the Oracle cloud environment! :-) I had to make some adjustments/correct some typo's etc. If I send the zipped codebases to you via @. @.>, would that suit you? Or should I clone your GIT and push a branch?

Just let me know.

— Reply to this email directly, view it on GitHub https://github.com/j-sieben/UTL_APEX/issues/1#issuecomment-1097968033, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5J7YHHV3UNTDJXE3JJV3DVE2ZPTANCNFSM5I3IRQAQ. You are receiving this because you commented.