How to read the parameters of URL in oracle form

Question

Hi,

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

Ex: whenever I run the form it opens in a browser and the URL for the same is

http://112.10.0.10:7778/forms/frmservlet?config=pkamble

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

when we run oracle form using 10g then

I will appreciate the help !!

Answer 1

This is answered here

Answer 2

Hi Tony,

Thanks for your answer.

But, I am using Oracle forms 10g I have referred the link you have mentioned. At run time my URL will be like

http://112.10.0.10:7778/forms/frmservlet?config=pkamble

I have a trigger WHEN-NEW-FORM-INSTANCE in that I have added following block to know config part after the question mark of an URL, and when I have added the code as shown below in my .fmb file

if (:PARAMETER.config = 'pkamble') then

message ('Hi Pkamble');

end if;

I am getting an error Bad Bind variable 'PARAMETER.config '

Please suggest here.

Answer 3

Hi pkamble!

I don't know if you can read config parameter, but to read another parameter from URL your URL have to be like:

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

In your .fmb you will have to add 'name' parameter in the parameters block and then you could do something like:

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

Joel

Answer 4

Hi Prashant,

You are trying assign the inbuilt variable config to the parameter but actualy you have to name the parameter like

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

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

Answer 5

I want to pass an encrypted parameter (userid) to the frmservlet,but it is not identified there,How can I do this,Please email me to [email protected]