APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn

 

Tips & Tricks

Print
05
Mar

Referencing USER in APEX

Written by Richard Weug on Wednesday, 05 March 2014 16:00. Posted in Tips and Tricks

It’s not uncommon to reference the current user as USER in your pl/sql code. A simple use case may be to determine the client or environment that you’re running in (ex: dev, test, prod).

Referencing USER will have some slight side effects when running the code in APEX as the current USER is actually APEX_PUBLIC_USER (or what ever user you configured). This can cause issues in your application. To resolve it, simply reference sys_context('userenv','current_schema’) instead.

Print
28
May

Include Images with Supporting Objects on APEX Export/Import

Written by Richard Weug on Tuesday, 28 May 2013 10:37. Posted in Tips and Tricks

If you have a logo or some other custom icons that you have uploaded in the 'Shared Components' of the application, there is an easy way to include these with your application export, so they will be automatically imported when you install your app elsewhere.

Print
26
May

Count URL clicks

Written by Richard Weug on Sunday, 26 May 2013 15:10. Posted in Tips and Tricks

This is a demonstration of using a two-step dynamic action to track how recently link columns from an APEX report have been clicked, based on a request from a lady I met at the KScope11 conference. The report is based on the following table:

Print
12
Apr

MP3 player in Apex

Written by Richard Weug on Friday, 12 April 2013 09:33. Posted in Tips and Tricks

Print
12
Apr

Low cost APEX reporting tool (Excel)

Written by Richard Weug on Friday, 12 April 2013 09:31. Posted in Tips and Tricks

Plug-in uses the source queries of all report regions on a page (standard or interactive) to fetch and convert data to temporary XML with DBMS_XMLGEN package. Plug-in then applies on temporary XML one or two XSLT transformation with XSLT processor implemented as DBMS_XSLPROCESSOR package. If we can’t build desired output just with XSLT final conversions can be made with ConverBlob procedure. Plug-in then starts download of transformed output. XSLT transformations must be previously uploaded in APEX application as static files.