Placeholder With a Call to a Database Function is not Working in Auto-narrative (Doc ID 2938283.1)

Last updated on JULY 13, 2023

Applies to:

Goal

Have a placeholder in CFG_PLACEHOLDERS which is calling a database function in the SQL_QUERY column.

But the output of the function is not getting replaced with the placeholder, instead, the PLACE_HOLDER itself appears in the output.

Placeholder name: [EVENT_ASSESS_DETAILS]
Placeholder Query: SELECT AN_EVT_ASSESS(:P_LET_CASE_ID) FROM DUAL

The output of the function when executed independently executes successfully and returns the expected output.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.