Content Page items :P1_ITEM reference in sql /plsql on page designer(only) &P1_ITEM. Static Text (exact)Note: Exact substitution syntax should be avoided in SQL or PL/SQL code because it can result in SQL Injection vulnerabilities #P1_ITEM# template v(‘P1_ITEM’), nv(‘P1_ITEM’) – ! it is not deterministic function , can lead to performance issue on heavy queries on…
Category: APEX
Use BitBucket Pipelines to Automate Oracle APEX deployment
Branch Strategy Runners Create bitbucket-pipelines.yml here is an example of a feature branch and with explainations. Tagging in pipeline How flyway works? SQLcl to export / install APEX applications To be able to install an exported application, the apex parsing schema need to have such role “APEX_ADMINISTRATOR_ROLE”
Oracle APEX Mail Relay Docker
It seems that APEX 23.1.0 made some changes to its smtp mail settings. I was no longer able to use straight smtp setting from my mail server. This behavior is also on APEX on ATP. For mail services on ATP, I use oracle oci mail service. It requires some setting on my dns settings. It…
How List/Create/Delete files in OCI bucket within APEX (plsql) + Create Pre-Authenticated Request
OCI account OCI user which has read/write access to the Bucket On that User create an API key Download the private key and click on “Add“ Keep OCI window open Open APEX screen Go to Workspace Utility find web credentials create new web credentialsgive it a name like OCI_AUTH Authentication Type: Oracle Cloud InfrastructureOCI UserID :…
Migrate APEX to Autonomous Database with custom ORDS (notes)
Create And Manage Your Custom ORDs credits goes two these two links https://fuzziebrain.com/content/id/2004/ https://www.linkedin.com/pulse/run-your-oracle-apex-apps-autonomous-database-own-domain-kurt-liu/ How to enable web sql-developer https://host/ords/sql-developer two ways to enable it. Go to Apex and enable rest for the parsing schema. make your the alias is in smallcase. or logon to the schema and write this plsql block to enable it….
Oracle APEX Interactive GRID with customised buttons on the tool bar
The goal is to have a custom button on the IG toolbar but doing something other than the regular functions provided by IG, in my example I am trying to achieve two things open dialog (via a button) execute some custom JS codes reportsGroupControls = toolbarData.toolbarFind(‘actions4’).controls; See more about actions4 here.
Oracle APEX Ords Oauth2 Notes
Create Role Create Privilege assign role to privilege Map privilege to pattern (modules/ parent end point ) defined in apex or with plsql api Create Client and give privilege created earlier Grant Role to Client Get Client_Id and Client_secret Test in Postman newer version of postman => Read more here.
Use Bastion Service to Connect To Autonomous DB within a private subnet PLSQL Developer
Validate VCN security list ingression rule. Find your database subnet check security list settings if 1522 ingress rule not existing, add it Create A Bastion in the same VCN or existing bastion in the same VCN where your Autonomous DB reside Create Session Open SSH Tunnel “-i <privateKey>” is not needed since we use public…
Oracle 21 XE, APEX, ORDs, Nginx as Load Balancer, PLSQL WS Proxy Installation Notes
High level design Database & APEX installation Linux ORDs Installation Nginx load balancer configuration Nginx PLSQL Webservice Proxy server configuration High level design Database & APEX installation Oracle 21XE installation Oracle APEX installation Database Installation For Oracle 21XE installation, i would suggest to follow this oracle official guide, it is pretty straight forward. (I assume…
My notes to create a simple AOP like server to process office documents(ongoing)
Goal: shopping list: Test with POSTMAN Or On APEX PHP Code