Andrew Schultz
@schultzapex.bsky.social
Oracle APEX developer since version 3.2. Spreading the joy of #orclapex #LowCode and #OracleAutonomous to nonbelievers across the stack.
Reposted by Andrew Schultz
I uploaded all my slides on my website: hartenfeller.dev/talks/
Talks and Publications
List of conference talks and publications
hartenfeller.dev
June 24, 2025 at 11:58 AM
I uploaded all my slides on my website: hartenfeller.dev/talks/
Reposted by Andrew Schultz
Today's fun discovery
ALTER SESSION DISABLE COMMIT IN PROCEDURE
=> if a PL/SQL procedure has a commit it raises an ORA-00034 instead!
=> you can rollback across PL/SQL calls with commits
Note: DML in the proc is rolled back unless you catch the ORA-34
This "new" feature is at least 20 years old!
ALTER SESSION DISABLE COMMIT IN PROCEDURE
=> if a PL/SQL procedure has a commit it raises an ORA-00034 instead!
=> you can rollback across PL/SQL calls with commits
Note: DML in the proc is rolled back unless you catch the ORA-34
This "new" feature is at least 20 years old!
February 20, 2025 at 9:54 AM
Today's fun discovery
ALTER SESSION DISABLE COMMIT IN PROCEDURE
=> if a PL/SQL procedure has a commit it raises an ORA-00034 instead!
=> you can rollback across PL/SQL calls with commits
Note: DML in the proc is rolled back unless you catch the ORA-34
This "new" feature is at least 20 years old!
ALTER SESSION DISABLE COMMIT IN PROCEDURE
=> if a PL/SQL procedure has a commit it raises an ORA-00034 instead!
=> you can rollback across PL/SQL calls with commits
Note: DML in the proc is rolled back unless you catch the ORA-34
This "new" feature is at least 20 years old!
Reposted by Andrew Schultz
This is going to be big!
Want to put a #database transaction "to sleep", do other stuff, and return to it later?
You can do this in Oracle Database from 23.6 with DBMS_TRANSACTION
This enables stateless REST APIs to run transactions over many calls
@thatjeffsmith.com shows you how
You can do this in Oracle Database from 23.6 with DBMS_TRANSACTION
This enables stateless REST APIs to run transactions over many calls
@thatjeffsmith.com shows you how
Sessionless Transactions in Database 23ai & your REST APIs
With the latest innovations in Oracle 23ai, you can now work with an Oracle session transaction over MULTIPLE HTTPS REST API calls! Here's a demo with ORDS.
buff.ly
February 19, 2025 at 7:54 PM
This is going to be big!
I believe #orclapex idea FR-2817 deserves to be reconsidered. We need a definitive place to report APEX bugs. Not the current setup that consists of using service requests, social media, email, the APEX forum, etc… @apexapplab.dev @jaysonhanes.bsky.social
apexapps.oracle.com/pls/apex/r/a...
apexapps.oracle.com/pls/apex/r/a...
January 29, 2025 at 4:08 PM
I believe #orclapex idea FR-2817 deserves to be reconsidered. We need a definitive place to report APEX bugs. Not the current setup that consists of using service requests, social media, email, the APEX forum, etc… @apexapplab.dev @jaysonhanes.bsky.social
apexapps.oracle.com/pls/apex/r/a...
apexapps.oracle.com/pls/apex/r/a...
January 15, 2025 at 4:45 PM
Reposted by Andrew Schultz
The United Codes team is heading to @odtug.bsky.social Kscope25 in Dallas - Fort Worth this June. Will you join us?
For a limited time, get last year's pricing, plus stack our discount code, VUC25, for an extra $100 off.
Register here: odtug.com/kscope25
#Kscope25 #orclapex #orcldb
For a limited time, get last year's pricing, plus stack our discount code, VUC25, for an extra $100 off.
Register here: odtug.com/kscope25
#Kscope25 #orclapex #orcldb
January 9, 2025 at 5:41 PM
The United Codes team is heading to @odtug.bsky.social Kscope25 in Dallas - Fort Worth this June. Will you join us?
For a limited time, get last year's pricing, plus stack our discount code, VUC25, for an extra $100 off.
Register here: odtug.com/kscope25
#Kscope25 #orclapex #orcldb
For a limited time, get last year's pricing, plus stack our discount code, VUC25, for an extra $100 off.
Register here: odtug.com/kscope25
#Kscope25 #orclapex #orcldb
#orclapex Idea Submitted: No Page Item Required for GET_BLOB_FILE_SRC.
apexapps.oracle.com/pls/apex/r/a...
apexapps.oracle.com/pls/apex/r/a...
apexapps.oracle.com
December 12, 2024 at 5:35 PM
#orclapex Idea Submitted: No Page Item Required for GET_BLOB_FILE_SRC.
apexapps.oracle.com/pls/apex/r/a...
apexapps.oracle.com/pls/apex/r/a...
Reposted by Andrew Schultz
Please join me for our first Oracle ACE Virtual conference on Dec. 11th! ♠️
With sessions from our amazing ACE speakers on:
🔥 Gen AI
🏆 Java
💥 Oracle Database@Azure
🎉 JSON Relational Duality
✨ Fusion Apps
⚡ OCI
Register for this FREE event here: apex.oracle.com/go/oracleace...
With sessions from our amazing ACE speakers on:
🔥 Gen AI
🏆 Java
💥 Oracle Database@Azure
🎉 JSON Relational Duality
✨ Fusion Apps
⚡ OCI
Register for this FREE event here: apex.oracle.com/go/oracleace...
December 4, 2024 at 5:15 PM
Please join me for our first Oracle ACE Virtual conference on Dec. 11th! ♠️
With sessions from our amazing ACE speakers on:
🔥 Gen AI
🏆 Java
💥 Oracle Database@Azure
🎉 JSON Relational Duality
✨ Fusion Apps
⚡ OCI
Register for this FREE event here: apex.oracle.com/go/oracleace...
With sessions from our amazing ACE speakers on:
🔥 Gen AI
🏆 Java
💥 Oracle Database@Azure
🎉 JSON Relational Duality
✨ Fusion Apps
⚡ OCI
Register for this FREE event here: apex.oracle.com/go/oracleace...
Read my latest #orclapex blog post on using IS_COMPONENT_USED to enforce defined conditions in a query. Expands upon the ideas introduced by Anton Nielsen with his blog.
@oracleapex.bsky.social
traust.com/blog/using-a...
@oracleapex.bsky.social
traust.com/blog/using-a...
An Amazing API: IS_COMPONENT_USED in APEX
Unlock the power of IS_COMPONENT_USED in Oracle APEX. This function can enforce conditions you've already defined in Shared Components.
traust.com
December 3, 2024 at 2:37 PM
Read my latest #orclapex blog post on using IS_COMPONENT_USED to enforce defined conditions in a query. Expands upon the ideas introduced by Anton Nielsen with his blog.
@oracleapex.bsky.social
traust.com/blog/using-a...
@oracleapex.bsky.social
traust.com/blog/using-a...