CODEWITHSUNDEEP
oracle-databaseoracle-apexapexapex-code
NoOneDer
NoOneDer

Reputation: 59

Oracle Apex past Value using Dynamic Link Item

So I have a link on my SQL query. It can navigate to the next page. But the thing is, I cannot carry the host_id(PK) to the next page: Anyone suggestion?

enter image description here

Upvotes: 0

Views: 1012

Answers (1)

Littlefoot
Littlefoot

Reputation: 143063

Concatenate it.

select 
'...:P39_COPY_HOST_ID:' || host_id ||'"...'
from ...                -------------
                        this

Or, even better, use apex_page.get_url function:

select ...
  '<a href="' ||
    apex_page.get_url(p_page   => 39,
                      p_items  => 'P39_COPY_HOST_ID',
                      p_values => host_id)
              || '"</a>' as link
from ...

Upvotes: 3

Related Questions