Andrew Schultz

I uploaded all my slides on my website: hartenfeller.dev/talks/

ODTUG socks.

In the same way you can detect vampires by using a mirror, you can detect an ODTUG member by their socks #kscope25

Earned my 2025 Professional Oracle APEX Cloud Developer Certification. Thank you to #orclapex and #oracle for providing free certification opportunities.

#orclapex

I didn’t see a time for breakfast on the newly released #kscope25 agenda. Is breakfast provided this year?

The PL/SQL procedure P contains an insert and rollback. After calling P you can't roll back work done before it.

After disable commit in procedure; calling P raises an exception instead of committing. This means you can rollback changes before calling P. As the exception is unhandled, the insert inside P is rolled back due to statement level consistency

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!

This is going to be big!

There is also this site: apex.oracle.com/pls/apex/f?p...

A central place would be equally nice to see what bugs have been submitted so the team doesn’t get slammed with duplicates. I imagine that APEX ideas used to be sent to the team in the same disjointed pathways before the app

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...

#orclapex

The page to download 24.1 is giving a 404. Does anyone know when it will be back up?

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

#orclapex Idea Submitted: No Page Item Required for GET_BLOB_FILE_SRC.

apexapps.oracle.com/pls/apex/r/a...

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...

#KSCOPE25 Abstracts Submitted #orclapex

Dynamic JavaScript Storage
APEX and Human vs AI: Job Posts and Candidates

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.

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...

Around that same time, your APEX blog was the first APEX blog I followed :)

Thank you for sharing. The one I typically use is:

^\S+@\S+\.\S+$

Too bad it doesn’t already exist, then you could add the project to the TO-DO app

Hello World! Happy to reconnect to the #orclapex community!

Could you add me to the pack?