How to Build Row Level Comments on a Report with the Oracle APEX Comments Theme Component

In just 7 min. we will show you how to enhance any existing APEX Report by adding the ability for users to comment on an individual row inside the report. The video begins by creating a template table to store the contents inside and a sample table of baseball player data for our report. Once created and data load we will create a new page as a modal form. Inside the form we will add a new region and show how to wire the region to our comments table and leverage the Oracle APEX theme component to browse and edit comments. We will showcase how to restrict comment editing to only the user creating the comment and then demonstrate how it works with multiple users entering information.
If you are not familiar with the APEX theme component we advise you watch this video first:
• Intro to the APEX Comm...
If you would like to try this out, please follow the steps in my git repo here:
github.com/chi...
Please note this video leverages APEX 23.1.2 inside a OCI free tier ATP instance.
#codeinnovate #apex #oracle #oci #developer

[@yoshithabuddha]

soooooooo helpful thank you sir

[@chipbaber]

Happy to help

[@AdamKowalski-ng6rx]

ORA-43929: Collation cannot be specified if parameter MAX_STRING_SIZE=STANDARD is set. When i tried creating frist table :/

[@chipbaber]

I am not sure what version of the DB you are on, but you will want to se the MAX_STRING_SIZE to Extended to correct this error as the example leverages a 23.2 autonomous database. The fix is, ALTER SYSTEM SET MAX_STRING_SIZE=EXTENDED SCOPE=BOTH; This enables the maximum value of varchar2 (also nvarchar2 and raw) from 4k (4096) to 32k (32767). If you are using an older version of the DB then please check with your dba before doing this as it could cause application instability for older apps.

[@GwadarDevelopmentAuthority]

Grrrrrrrrrrrrrr8 sir

[@chipbaber]

Glad you like it