CODEWITHSUNDEEP
oracle-databaseplsqloracle-apex
Maharjan
Maharjan

Reputation: 176

How to get the params of URL in oracle apex?

I have my url like this

apex/f?p=910:16:2997302969983::NO::P13_LOGIN_ID:2003

Is is possible to get it from PL/Sql(anonymous block) ?

Upvotes: 0

Views: 4748

Answers (2)

user8105223
user8105223

Reputation: 1

Yes, this is possible :

f?p=&APP_ID.:102:&SESSION.::NO:::&KEYCODE=NO_&USER_ID.

Upvotes: 0

bprasanna
bprasanna

Reputation: 2453

You can use v('P13_LOGIN_ID') or :P13_LOGIN_ID to retrieve the value of P13_LOGIN_ID.

Example:

begin
   if v('P13_LOGIN_ID') = 2004 then
      //Do processing
   elsif :P13_LOGIN_ID = 2003 then
      //Do processing
   end if;
end;

Upvotes: 1

Related Questions