Tag Archives: ORACLE

APEX 5: Showing custom success message from Dynamic Action (DA) on Universal Theme

I needed to show a success message after ending a Dynamic Action and I wanted this message to be with the same format as success messages from page processes. Since this is not a standard feature of Oracle APEX, you can do the following trick if you’re using Universal Theme: Create a JavaScript function which […]

Comments ( 0 )

Oracle APEX 5.0: How-to call modal page from dynamic action and capture close event

Today I needed to submit a page saving data and opening a modal page afterwards. For my surprise, APEX 5.0 raises an “400 – Bad request” error when calling a modal page from “Branch” section after processesing (calls apex.navigation.dialog without stating “javascript:” sentence first). It seems to be a Bug of 5.0 version (which hopefuly […]

Comments ( 1 )

APEX Relational Flexfield plugin – Tutorial

In this post I’ll guide you on how to use “flexfield” APEX plugin. For a online demo, you can access: https://apex.oracle.com/pls/apex/f?p=JOSEPCOVES:FLEXFIELDS Let’s assume we want to provide admin users the ability to fill some table fields with their own specification. We assume you have your own demo “EMP” table with employee information. 1. First of […]

Comments ( 0 )

APEX Relational Flexfield plugin – Tutorial

In this post I’ll guide you on how to use “flexfield” APEX plugin. For a online demo, you can access: https://apex.oracle.com/pls/apex/f?p=JOSEPCOVES:FLEXFIELDS Let’s assume we want to provide admin users the ability to fill some table fields with their own specification. We assume you have your own demo “EMP” table with employee information. 1. First of […]

Comments ( 2 )

UTL_SMTP Sending HTML e-mails with multiple BLOB attachments via custom SMTP Server

The last few days I’ve been struggling with Oracle APEX trying to send e-mails via APEX_MAIL from different SMTP servers. But since SMTP configuration is at Instance level, it’s not that easy neither secure to keep changing instance settings and sending e-mails. (you can see the whole information at the oracle forum: https://forums.oracle.com/forums/message.jspa?messageID=10376262#10376262). Resuming I […]

Comments ( 0 )