rhinterndorfer

select * 
from
(
select 1 id,
    'Tom Hanks' text,
    'male' gender
from dual    
union all
select 2 id,
    'Bill Murray' text,

rhinterndorfer

$( document ).ajaxSend(function( event, jqxhr, settings ) {
    // check if the request url is "wwv_flow.ajax" and contains data
    if(settings.url == "wwv_flow.ajax" && settings.data) {
        try {
            // extract the JSON payload from the request url
            var jsonPayloadMatch = settings.data.match(/(?<=p_json\=).*/);
            if(jsonPayloadMatch && jsonPayloadMatch.length > 0) {
                // decode and unescape URL payload
                // and parse JSON
                var json = JSON.parse(unescape(decodeURI(jsonPayloadMatch[0])));

rhinterndorfer

-- alter session set container=XEPDB1; -- select container with Oracle APEX installation
exec apex_instance_admin.set_parameter('APEX_BUILDER_AUTHENTICATION','APEX');

rhinterndorfer

procedure post_auth is 
    l_count number;
    l_roles varchar2(1024);
begin 
    :G_AUTH_SCHEME := 'IdentityServer'; 
    l_roles := '';
    IF apex_json.does_exist(p_path => 'role') THEN

        BEGIN
            l_count := apex_json.get_count(p_path=>'role');

rhinterndorfer

// clients want to access resources (aka scopes)
        public static IEnumerable<Client> GetClients()
        {
            // client credentials client
            return new List<Client>
            {
                // OpenID Connect 
                new Client
                {
                    ClientId = "PLAYGROUND",

rhinterndorfer

{
  // -------------------------------------------------------------------------
  // Active directory
  // -------------------------------------------------------------------------
  "ldapActiveDirectory": {
    "url": "sso.rammelhof.at",
    "port": 389,
    "ssl": false,
    "bindDn": "CN=svcLdap,OU=Services,DC=dev,DC=local",
    "bindCredentials": "!password!",

rhinterndorfer

%windir%\system32\inetsrv\appcmd.exe set config -section:system.webServer/proxy -preserveHostHeader:true /commit:apphost

rhinterndorfer

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
        <httpRedirect enabled="false" destination="http://localhost:8080" />
        <rewrite>
            <rules>
                <clear />
                <rule name="https" stopProcessing="true">
                    <match url="(.*)" />
                    <conditions logicalGrouping="MatchAll" trackAllCaptures="false">

rhinterndorfer

$( document ).ajaxSend(function( event, jqxhr, settings ) {
    // check if the request url is "wwv_flow.ajax" and contains data
    if(settings.url == "wwv_flow.ajax" && settings.data) {
        try {
            // extract the JSON payload from the request url
            var jsonPayloadMatch = settings.data.match(/(?<=p_json\=).*/)
            if(jsonPayloadMatch && jsonPayloadMatch.length > 0) {
                // decode and unescape URL payload
                // and parse JSON
                var json = JSON.parse(unescape(decodeURI(jsonPayloadMatch[0])));

rhinterndorfer

select * 
from
(
select 1 id,
    'Tom Hanks' text,
    'male' gender
from dual    
union all
select 2 id,
    'Bill Murray' text,