--- title: "Joe Kerr (@jkerr) | Hashnode" description: "Delivering real value with innovative strategies and solutions. Read the latest articles by Joe Kerr on Hashnode." url: "https://hashnode.com/@jkerr" --- @jkerr # Joe Kerr @jkerr · Florida, US · Joined August 2022 Delivering real value with innovative strategies and solutions [Website](https://softpath-inc.com/) ## Comments [This is great, thanks. Did you also OCR the documents? How will they be retrieved / indexed?](https://hashnode.com/posts/bulk-uploading-25-million-files-to-oci-object-storage/684ac250c68b81afc2083ee8/comment/684c0648ee209a759cdae35d) Comment · Article · Jun 13, 2025 · [Bulk Uploading 25 million files to OCI Object Storage](https://hashnode.com/posts/bulk-uploading-25-million-files-to-oci-object-storage/684ac250c68b81afc2083ee8) [The comparison is very helpful and informative. As far as "Improved printing and PDF export" Document Generator is a good first installment but compare to AOP and there is a long way to go and still more to be done at the basic reporting level. This includes easier integration with APEX. Hoping this doesn't mean Document Generator is done.](https://hashnode.com/posts/oracle-apex-roadmap-changes-2024-2025/68469829ade64f948b16709a/comment/684c05127d50ec8c6a66803a) Comment · Article · Jun 13, 2025 · [Oracle APEX Roadmap Changes 2024-2025](https://hashnode.com/posts/oracle-apex-roadmap-changes-2024-2025/68469829ade64f948b16709a) [This is very helpful.Note: APEX\_Application\_Admin.Set\_Application\_Status parameters also changed in 24.2. the p\_unavailable\_value has become: p\_redirect\_url / URL to redirect to when p\_application\_status = c\_app\_unavailable\_redirect.](https://hashnode.com/posts/instant-maintenance-mode-for-oracle-apex-apps/682dcd756faa7934730795d6/comment/6830cea7b379f554dff01349) Comment · Article · May 23, 2025 · [Instant Maintenance Mode for Oracle APEX Apps](https://hashnode.com/posts/instant-maintenance-mode-for-oracle-apex-apps/682dcd756faa7934730795d6) [I am trying to implement this with a more complicated query. Thoughts on a where clause like this, or one using between and dates? ( VW\_Person.Person\_Number = :APP\_PERSON\_PERSON Or :APP\_IS\_ADMIN = 'Y') And ( :P21\_CRITERIA\_STATUS = 'A' AND STATUS\_TRAN\_PERSON = 'ACTIVE' OR :P21\_CRITERIA\_STATUS = 'I' AND STATUS\_TRAN\_PERSON = 'INACTIVE' OR :P21\_CRITERIA\_STATUS NOT IN ('A', 'I')) And (:P21\_CRITERIA\_EPRGENRL\_ID IS NULL OR Employer\_ID = :P21\_CRITERIA\_Employer\_ID); Note: Criteria\_Status is a group letting the user select (A)ctive, (I)nactive, or Al(L) people. Thanks Joe](https://hashnode.com/posts/writing-fast-queries-in-apex/67dd8f8b5b905023af864ac2/comment/67e847f87c8e2b9bf7fcf6cd) Comment · Article · Mar 29, 2025 · [Writing Fast Queries in APEX](https://hashnode.com/posts/writing-fast-queries-in-apex/67dd8f8b5b905023af864ac2) [Very helpful both for the code, and the perspective. Are there security concerns here from having a function that creates a query from inputs vs. a "hard coded" query?](https://hashnode.com/posts/writing-fast-queries-in-apex/67dd8f8b5b905023af864ac2/comment/67e7db0fd046255723a17507) Comment · Article · Mar 29, 2025 · [Writing Fast Queries in APEX](https://hashnode.com/posts/writing-fast-queries-in-apex/67dd8f8b5b905023af864ac2) [Thanks, this is very helpful. Is there a way to select which column value is returned, or is it always the primary key?](https://hashnode.com/posts/oracle-apex-working-with-row-selection-in-interactive-grid/67af40c30552adb9e39f742d/comment/67e462afd8ffb48087ee11aa) Comment · Article · Mar 26, 2025 · [Oracle APEX: Working with Row Selection in Interactive Grid](https://hashnode.com/posts/oracle-apex-working-with-row-selection-in-interactive-grid/67af40c30552adb9e39f742d) [Very nice. FYI: Read my blog series "Mastering SQLcl Liquibase" link is broken.](https://hashnode.com/posts/install-sqlcl-with-liquibase-on-macwindows-and-use-it-with-oracle-database-on-premise-cloud/65afe2b3b1ecb277d0daaec4/comment/67d4194856b2772361013544) Comment · Article · Mar 14, 2025 · [\[Oracle SQLcl Liquibase\] Install it on Mac&Windows and use it with Oracle Database (on-premise & cloud)](https://hashnode.com/posts/install-sqlcl-with-liquibase-on-macwindows-and-use-it-with-oracle-database-on-premise-cloud/65afe2b3b1ecb277d0daaec4) [Jon Dixon Hi Jon, FYI I went the dbms\_scheduler route, but setting argument values for a PLSQL\_BLOCK generates an error saying that type does not allow arguments. I handled it by pre-constructing the job\_action to build the parameter values into the job\_Action parameter value. Thanks again, Joe](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66ef5f60e3f72d0f3cbd3af4#reply-66f2e23cb20a3b7789d8dd10) Reply · Article · Sep 24, 2024 · [APEX Background Page Processing - The Definitive Guide](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4) [Jon Dixon Hi Jon, Thanks for the quick and helpful options. I am thinking a good APEX Idea could be making it possible to fire a process with a custom event similar to DAs? Joe](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66ef5f60e3f72d0f3cbd3af4#reply-66f05502ccc0f78100865258) Reply · Article · Sep 22, 2024 · [APEX Background Page Processing - The Definitive Guide](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4) [Very well done, and helpful.I have an IG using FOS plugin to add Menu Items to "Actions Menu" that trigger a custom event that causes a Dynamic Action to fire executing PL/SQL code using Primary Keys of currently selected IG rows and other page item values. I want to move the PL/SQL code to a background process and cause it to fire as one of the actions of the Dynamic Action. Ideas on how to do that? In short, how to fire a background Process from a Dynamic action that uses Page Item values? It seems it has to be a button click event? Or a submit, but then I lose which items were selected? Thoughts? Thanks Joe](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4/comment/66ef5f60e3f72d0f3cbd3af4) Comment · Article · Sep 22, 2024 · [APEX Background Page Processing - The Definitive Guide](https://hashnode.com/posts/apex-background-page-processing-the-definitive-gude/66ec1d8a297094b056ab70b4)