Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can you dynamically get the page number you are on in oracle apex? [closed]

I need to write to a page dynamically based on what page I am on using pl/sql. I don't know if it is possible, but can you get the page number you are on within pl/sql. For example with items you can use :P12_ITEM_NAME in order to get a certain item on a page, is there something similar to get the current page number?

Thanks.

like image 751
Chris Conaty Avatar asked Dec 24 '22 15:12

Chris Conaty


1 Answers

If you're within a page, you can just use :APP_PAGE_ID. But if you're within a page, you'd generally know what page you're on.

If "within PL/SQL" means that you're calling a PL/SQL procedure or function that is defined in the back end database, you'd want nv('APP_PAGE_ID') (you could use v('APP_PAGE_ID') if you want it returned as a string rather than a number for some reason).

like image 171
Justin Cave Avatar answered Jan 09 '23 19:01

Justin Cave