Show the message generated from the PL/SQL process

We need to show the messages from the PL/SQL process (back-end) to the user (front-end) very often.

One way is to use the global variable APEX_APPLICATION.G_PRINT_SUCCESS_MESSAGE. The Apex will shows the message in the upper right corner with the green box. The method is suitable for showing information that doesn’t need the user to interact with.

The second way is to use APEX_ERROR.ADD_ERROR procedure to add the message to the error stack. When loading the page, the Apex will show these messages. We can specify the locations of showing the messages either on the upper right corner or associate with pages items or event an error page. However, the APEX_ERROR.ADD_ERROR procedure will interrupt the request processing process such that the codes after the APEX_ERROR.ADD_ERROR will not be executed. The method is appropriate for the form validation.

This article presents another way to show the message from the PL/SQL process. We use the Application Item to store the message from the PL/SQL process. There is a Application Process executing on the page loading to show the message in the Application Item using the JS functions in the apex.message namespace.

See the full article: https://hychen39.github.io/oracle_apex/2018/10/17/apex_messages_app_item.html

Enhance orclapex maven plugin to use NaturalDocs 2.x to generate pl/sql API documents.

Use the orclapex maven plugin with the NaturalDocs 2.x to generate pl/sql API document.

See https://github.com/hychen39/orclapex-maven-plugin/blob/master/README-1.0.4.md.

使用 Maven 匯出 Apex Application file 到本地端電腦

Export Oracle Apex Application from remote to local computers using Maven

Abstract
Oracle Apex application needs to be exported as a sql file from the Workspace in order to deploy to another workspace. Other than exporting manually, this article introduces an automatic way to export the Apex file and copy it to the local computer by using Maven. The automation enables automated build and release process.

Full article:
https://hychen39.github.io/oracl_apex/2018/08/29/export_apex_app_maven.html

在 Apex 由後端程式顯示自訂訊息

全文參考 : https://hychen39.github.io/oracle_apex/2018/08/29/apex_messages.html

Oracle ORDS 404 Not Found Trouble Shooting

整理解決 安裝 Oracle  ORDS  做為 Oracle Apex 的 Listener 時產生的 404 Not Found 的步驟.

全文參考: https://hychen39.github.io/oracle_apex/2018/08/24/ords_404_trouble_shooting.html

使用 Maven 自動部署 Natural Doc 編譯完成的 api document 到指定的 Web Server

全文請參考: https://github.com/hychen39/tech-doc/blob/master/oracle-apex-ying-yong-cheng-shi-kai-fa/us83_maven_deploy_api_doc_.md