OraFAQ Forum: Forms » Reading a Query String (url parameters) in Oracle forms 11g

Home » Developer & Programmer » Forms » Reading a Query String (url parameters) in Oracle forms 11g (oracle forms 11g, )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reading a Query String (url parameters) in Oracle forms 11g [message #607758]

Tue, 11 February 2014 10:34

prathameshpitale
Messages: 4
Registered: January 2014
Location: Ahmednagar

Junior Member

Hello,

I am Invoking Oracle forms from an external application, and I need to capture the data sent by the external app. using query string in the URL.

For eg. the URL is http://prathamesh-pc:7002/forms/frmservlet?form=text.fmx&MyPersonalCode=omomom

Now I need to capture the mypersonalcode Parameter from the URL and Display on the Form.

Please Guide.

Report message to a moderator

Re: Reading a Query String (url parameters) in Oracle forms 11g [message #660411 is a reply to message #607758]

Wed, 15 February 2017 22:53

AliBukhari
Messages: 1
Registered: February 2017

Junior Member

To pass the parameters in URL you should write the URL in this form.
http://prathamesh-pc:7002/forms/frmservlet?form=text.fmx&otherparams=MyPersonalCode=omomom

Add &otherparams in link for passing the parameters.

Now in second form add parameter in parameters block like MyPersonalCode and add this code in When-New-Form-Instance Trigger

if :parameter.MyPersonalCode = 'omomom' then
 -- do some thing 
end if;

You can also pass multiple parameters in query string by adding + Plus Sign like this
http://prathamesh-pc:7002/forms/frmservlet?form=text.fmx&otherparams=MyPersonalCode=omomom+par2=somevalue+para3=somevalue

Report message to a moderator

Re: Reading a Query String (url parameters) in Oracle forms 11g [message #660415 is a reply to message #660411]

Thu, 16 February 2017 00:19

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm afraid you missed the point. The question is NOT how to pass parameters; some application calls the form using URL; the form is displayed on the screen, and the OP now wants to display - in one of form's items - value of a parameter passed via URL.

So, it is quite the opposite - how to parse URL and extract information from it (while URL resides in web browser's address line).

Anyway: it is nice to see a new Forum member (welcome!) whose first message is an attempt to help someone. Perhaps you could try to answer more recent questions, as this one is 3 years old.

Report message to a moderator

Previous Topic:	ERRON IN ORACLE FORM 11.1.2.2.0
Next Topic:	Setting TextItem text from another TI

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 19 13:46:46 CST 2025