Skip to content

Instantly share code, notes, and snippets.

Dimitri Gielis dgielis

View GitHub Profile
dgielis / app_error_pkg.sql
Created Jun 30, 2018
Custom Error Handling function for APEX
View app_error_pkg.sql
create or replace package app_error_pkg
-- 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;
View ora_dev_cloud_pkg.sql
create or replace package ora_dev_cloud_pkg as
Purpose : Oracle Developer Cloud module
Version Date By Description
------- ----------- ---------------- ----------------------------------------------
0.1 22-FEB-2018 Dimitri First version, based on Dimitri's blog post
dgielis / oracle_apex_team_dev_2_bitbucket.sql
Last active Mar 13, 2018
Load Oracle APEX Team Development into Bitbucket issues
View oracle_apex_team_dev_2_bitbucket.sql
l_clob clob;
l_body clob;
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
dgielis / model_to_quicksql.sql
Last active Mar 15, 2019
Reverse engineer existing Oracle tables to Quick SQL
View model_to_quicksql.sql
l_prefix varchar2(15) := 'EBA_DBTOOLS';
l_spaces varchar2(10) := ' '; -- use '&nbsp;' in web
l_enter varchar2(10) := CHR(10); -- use '<br/>' in web
l_constraint varchar2(500);
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 / mtl_auth_pkg.pkb
Last active Dec 27, 2017
Multiplication Table: Custom Authentication package body for Oracle APEX
View mtl_auth_pkg.pkb
create or replace package body mtl_auth_pkg
* Constants
c_from_email constant varchar2(100) := '';
c_website constant varchar2(100) := 'my site';
c_hostname constant varchar2(100) := 'my hostname';
dgielis / mtl_auth_pkg.pks
Created Aug 29, 2017
Multiplication Table: Custom Authentication package for Oracle APEX
View mtl_auth_pkg.pks
create or replace package mtl_auth_pkg
* Project: Multiplication Table
* Author: APEX RnD - Dimitri Gielis
* Description: Custom Authentication and Authorization
* Note: None
* @headcom
You can’t perform that action at this time.