Hello everybody. Working with 23.2
I have this sql in the Master Record :
select "SURVEY_ID_X","SURVEY_ID",
null LINK_CLASS,
apex_page.get_url(p_items => 'P15_SURVEY_ID_X,P15_SURVEY_ID', p_values => 'SURVEY_ID_X,SURVEY_ID') LINK,
null ICON_CLASS,
null LINK_ATTR,
null ICON_COLOR_CLASS,
case when coalesce(:P15_SURVEY_ID_X,'0') = "SURVEY_ID_X"
then 'is-active'
else 'X '
end LIST_CLASS,
(substr("DESCRIPCION", 1, 50)||( case when length("DESCRIPCION") > 50 then '...' else '' end )) LIST_TITLE,
'' LIST_TEXT,
null LIST_BADGE
from "SURVEYS" x
where USER_ID = :P15_USER_ID AND (:P15_SEARCH is null
or upper(x."DESCRIPCION") like '%'||upper(:P15_SEARCH)||'%'
)
order by "DESCRIPCION"
I'm trying to pass two items to the apex_page.get_url procedure ( SURVEY_ID_X & SURVEY_ID), but when I tried to run the module, I received an ora-01722: The string value containing 'S' could not be converted to a number.
I suppose that I'm using wrong the get_url procedure but I don't know, I'm using it as in the tutorial.
Any help is welcome.
Thanks in advance and regards to everybody.