dgielis

create or replace package mtl_auth_pkg
as
  /**
  * Project:         Multiplication Table
  * Author:          APEX RnD - Dimitri Gielis
  * Description:     Custom Authentication and Authorization
  * Note:            None
  * @headcom
  */

dgielis

create or replace package body mtl_auth_pkg
as

/**
* Constants
*/

c_from_email constant varchar2(100) := 'no-reply@my.email';
c_website    constant varchar2(100) := 'my site';
c_hostname   constant varchar2(100) := 'my hostname';

dgielis

declare
  l_prefix varchar2(15) := 'EBA_DBTOOLS';
  l_spaces varchar2(10) := '  '; -- use ' ' in web
  l_enter  varchar2(10) := CHR(10); -- use '<br/>' in web
  l_constraint varchar2(500);
begin
  for t in (select t.table_name, 
                   case when m.comments is not null then ' [' || replace(replace(replace(m.comments,'[','{'),']','}'),CHR(10)) ||']' end as comments
              from user_tables t, user_tab_comments m,                                       
                   (select max(lvl) as lvl, table_name

dgielis

declare
  l_clob clob;
  l_body clob;
begin
  for r in (select feature_name as title, '*'||focus_area||'*' ||feature_description || ' ' || publishable_description || '' as description 
              from apex_team_features
             where nvl(feature_status,0) < 100 and nvl(focus_area,'A') <> 'ON HOLD')
                   -- change where to what you need
  loop  
    apex_json.initialize_clob_output;

dgielis

create or replace package ora_dev_cloud_pkg as
/*

   Purpose : Oracle Developer Cloud module

  history
  Version Date        By               Description
  ------- ----------- ---------------- ----------------------------------------------
  0.1     22-FEB-2018 Dimitri          First version, based on Dimitri's blog post

dgielis

create or replace package app_error_pkg
as
    --
    -- Function: apex_error_handling
    -- Purpose: Try to elegantly handle errors that occur while using the application.
    --
    function apex_error_handling (
        p_error in apex_error.t_error )
        return apex_error.t_error_result;
    --