Accessing URL parameters in Oracle Forms / OC4J

Dave Smylie picture Dave Smylie · Sep 22, 2008 · Viewed 7.4k times · Source

How do I access parameters passed into an Oracle Form via a URL. Eg given the url:

http://example.com/forms90/f90servlet?config=cust&form='a_form'&p1=something&p2=else

This will launch the 'a_form' form, using the 'cust' configuration, but I can't work how (or even if it's possible) to access p1 (with value of 'something') p2 (with value of 'else')

Does anyone know how I can do this? (Or even if it is/isn't possible?

Thanks

Answer

Tony Andrews picture Tony Andrews · Sep 22, 2008

Within Forms you can refer to the parameters p1 an p2 as follows:

  • :PARAMETER.p1
  • :PARAMETER.p2

e.g.

if :PARAMETER.p1 = 'something' then
   do_something;
end if;