How to read URL parameters in oracle form

Question

I am using Oracle form 10 I want to know how can I access the url parameters in oracle form

Example: whenever I run the form, it opens in the browser and the url for it is

I just want to know how I can access the value of the 'config' parameter inside the oracle form code.

when we run oracle form using 10g then

I would be grateful for your help!

0

pkamble 19 nov. '08 at 9:21

2 answers

Joel · Answer 1 · 2008-12-04T09:18:49+0000

I don't know if you can read the config parameter, but to read another parameter from the URL, your url should look like this:

http://112.10.0.10:7778/forms/frmservlet?config=pkamble&otherparams=name=value

In your .fmb, you will need to add the "name" parameter to the parameter block, and then you can do something like:

if :PARAMETER.name = 'value' then
 message('ok');
end if;

And for more than one parameter, use:

http://112.10.0.10:7778/forms/frmservlet?otherparams=name1=value1+name2=value2+name3=value3

ronnee · Answer 2 · 2009-12-09T07:25:38+0000

You are trying to assign the built-in config variable to a parameter but in reality you must specify a parameter, for example

if you want to use the predefine paramater then user get_application_property inbult function by oracle