QR Code Generation in Forms 12c

@SANPAT

Someone reached out to me with a question about QR codes in Oracle Reports. Shared in that question was a public utility that generates QR codes.

So, to my point. I wondered if I could use this to display QR codes in Forms 12c. As it turns out the answer is "yes". That said, now that I've had time to think about it I really don't know why you would want to do this unless you were printing the form. Anyway, in line with what I originally suggested, consider this (12.2.1.4 required for some of the settings):

.1. Create a form with a text field (e.g. DATA_IN). Set the max length of the field to 32767 (or some reasonable length more than 30)

.2. Add an image item to the form (e.g. QRCODE). Make these Property changes along with any other customization you want.

.3. Add a button (e.g. B_CREATEQR) with a WHEN-BUTTON-PRESSED trigger and this code:

READ_IMAGE_FILE ('https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=' || :DATA_IN, 'URL', 'QRCODE');

.4. Compile and run the form. In the text field enter some text then click the button. For example,

Hello%20world

Note that I have to include the HTML escape character for SPACE (%20) in order to deliver it correctly. You'll likely want to add the appropriate PLSQL to do this programmatically.

.5. Now scan the code with your phone or other device capable of translating the code. On my iPhone this is what I get:

Of course, in order for any of this to work the Forms app will need Internet access (mid tier).