Hi.
I am using APEX 5.1. My question is two-fold.
First I want to include 2 PL/SQL database stored function calls as a pseudo column in my GI query.
The SQL is something like:
SELECT ...
acs_ohp.host_kernel_check_fails ( host_guid -- <= Yet to be added.to my SQL
, :P114_TEMPLATE_ID) AS check_fail_count, -- <= Yet to be added.to my SQL
DECODE(acs_ohp.host_kernel_check_fails ( host_guid
, :P114_TEMPLATE_ID), 0, app_utl.get_style('STS_PASS'), app_utl.get_style('STS_FAIL')) as link_style,
HOST_GUID as view_link
FROM ...
I included the second expression / function already, setting...
Source Type to Database Column
Data Type to VARCHAR2
Query Only : Yes
Primary Key No.
Having done this I find that the column does not appear when I run the page (and is not showing in Action -> Columns.
The second expression returns some styling CSS, based on a which I want to apply to a link column, using #LINK_STYLE#. I wish to change the colour of the link icon, based on the function return.
The first expression (not yet implemented) includes the same function, which returns a count that I wish to display.
So, is there a problem with my approach here?
Thanks,
Clive