Anton Scheffer
209 posts

Anton Scheffer
@AntonScheffer
One of the developers of Oracle Application Express (APEX). The views expressed by me on 𝕏 are my own and do not necessarily reflect the views of Oracle.
Beigetreten Aralık 2013
5 Folgt244 Follower

@AntonScheffer Tested it with Claude Sonnet reasoning and the small test worked perfectly:
Dont know anything about ZugFerd so maybe it was just an easy example



English

I even built a reactive markdown plug-in (with table support) for the demos 😊.
#orclAPEX
Oracle ACE Program@oracleace
Join Oracle ACE @phartenfeller at United Codes, Live! See how easy it is to add AI to your PL/SQL apps using the free UC AI API—live demos in APEX included. social.ora.cl/6013A6Glf #OracleACE
English

Cleaning up an old laptop, so moving some stuff what still might be useful for others to github. See github.com/antonscheffer/… #orclAPEX #passkeys #WebAuthn
English

@plamen_9 Removing all registered passkeys, and registering new ones and it's working again. #orclapex #passkeys oracleapex.com/ords/r/test191…
English

⚠️ Remember to fix your APEX applications Social Sign-in settings!
The free APEX evaluation service is now moved to the domain - oracleapex.com. Which means that all of your applications, using Social Sign-in with Google, Office365, OKTA, etc. will fail unless you change the redirect URL in the SSO provider settings.
See an example with the Google settings 👇
console.cloud.google.com/auth/clients
The Redirect URI you need to use is:
oracleapex.com/ords/apex_auth…
PS: The old domain - apex.oracle.com - will be used for marketing purposes only.
#orclAPEX



English

@DeshBhagatDilSe Honestly, I've no idea. I don't have a version 13-06-2018 anymore. And I don't understand what you mean with a missing header row in the 14-08-2025 version
English

@AntonScheffer I used the as_xlsx dated 13-06-2018. When using as_xlsx.cell(p_col => 1, p_row=> 1, p_value => ‘valuefromcursor’, p_sheet=>1), it creates a header row. But when I used the same package dated 14-08-2025, it do not create header row. Could you provide reasons why?
English


🚀 Two great stories from VTTI and Hendrix Genetics about why they chose Oracle and APEX!
techzine.eu/blogs/infrastr…
#orclAPEX #LowCode
English

@ChieOkel Still working on it (sometimes). But you can try it out: github.com/antonscheffer/… #as_pdf #plsql
English

@AntonScheffer Eagerly awaiting your updated as_pdf.
It's been most useful. Many thanks.
English


Wow, my #plsql code will now survive for 1,000 years in an underground arctic vault 🤓
Pretty cool (literally!) 🥶
github.com/mortenbra
LaurieWired@lauriewired
If you see a github user with this badge it’s because they have code ~1,000 feet underground in the Arctic Circle. 5 years ago Github took a snapshot of all public repos, stored it on photographic film (essentially big QR codes), and stuck it in a mining tunnel.
English

@DenesKubicek @andre_blu And DENES can manipulate what he wants, and still can only delete records he is allowed to do so.
English

@DenesKubicek @andre_blu "The visible, editable record ID can be manipulated, leading to unauthorized data alterations or deletions." So I assume you have some authorization in place.
IF v('APP_USER' ) = 'DENES' and id in ( 1,2 ) THEN ... ELSE ... END IF;
(1/2)
English

Programming applications is a lot of fun with #orclapex. However, security is often neglected in the process. In this blog post, we highlight one of the most common mistakes related to hidden items and show how to do it correctly and securely. Have fun!
kubicek-consulting.de/ords/delete-wi…
English

@andre_blu @DenesKubicek All these steps are not needed when you check your authorization also in the DB
English

@DenesKubicek Problem is having to do so many steps to achieve something very common and that should be available out of the box. Not very low code... #orclapex
English

I'm very excited to be speaking at APEX Alpe Adria this Friday and meeting the #orclAPEX community there 🇭🇷
I hope to see you at my talk, “Why all APEX dev should learn more about HTML, CSS and web tech in general” 🤓
All the info on the event here 👇
aaapeks.info/home
English

@nl_OUG Maybe I missed something important, but I've no idea what Session X or Feature X is ❓❓❓😕
English

Dit wil je echt niet missen..!
Er zijn nog plaatsen vrij voor "Session X".
Een EXLCUSIEVE sessie over hoe je de integriteit van je databases naar een hoger niveau kunt tillen.
Reserveer je plaats snel want vol = vol.
nloug.nl/events/meetup-…

Nederlands

@j_kerr100 Something like antonscheffer/Multifactor-with-TOTP-Authenticator: A small Oracle APEX 23.2 app using TOTP as a second authenticaton factor??? #orclapex github.com/antonscheffer/…
English

FBI: 2FA texts and emails no longer secure. Want to make it easy to add Authenticator app and physical FIDO security key authentication to the APEX applications you build? Please vote for: apex.oracle.com/ideas/FR-4165 #orclapex
English

Someone asked this week about password protection a PDF with as_pdf3. I once had that working, but I couldn't find any sources. I did some 12 years old source with code to add password protection to an Excel file. So I quickly added that to #as_xlsx before I loose that too 😃

English

@alexsteinerde I was working on a plsql parser for putty private keys. For github.com/antonscheffer/…. Putty private keys are using Argon2. It takes 15 minutes to derive the encryption key. Looks like #PLSQL is not suitable for #Argon2 (openssh keys use #bcrypt, takes 30 sec)
English







