Oracle forms 6i call form via static ip [message #522068] |
Tue, 06 September 2011 05:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/428f06eb905e540cba82ae563ba913dd?s=64&d=mm&r=g) |
rajamohankumar
Messages: 26 Registered: July 2011 Location: TAMIL NADU
|
Junior Member |
|
|
Dear friends & experts,
I had a query related to call_form function in forms 6i.How can I call a particular form via static ip(outside LAN),but the actual forms are stored in a server called "MAIN_SERVER" which resides in internal LAN domain.That is I have stored location of all my forms path(fmx)in my database table called "FORMS_LOCATION" in the MAIN_SERVER system under the directory "FORMS".From here only users can call all the forms by call_form function.To understand see the example below,
In the table FORMS_LOCATION,there is a column call "forms_path" which holds the value like,
//MAIN_SERVER/FORMS/EMPLOYEE.FMX;
(server_name,foldername,form_name)
In application the call_form just uses the column "forms_path" to call the form.like CALL_FORM("forms_path",no_hide) this statement will call the form from the main_server.
Here 1.MAIN_SERVER is the name of the server system where forms fmx is actually stored under the folder name "FORMS".When the users access the particular form the call_form function call the form from the MAIN_SERVER.Now there are no problem inside the LAN.Incase if I access the database and call the form outside LAN via internet through STATIC IP what happened was database was connected but call_form function failed and not calling the form because which does not know the MAIN_SERVER/FORMS/ path.
Because my user want to access the form outside lan via internet,so I tried replacing the above statement like //192.54.67.98/FORMS/EMPLOYEE.FMX' with static ip in the prefix instead of local server called MAIN_SERVER.But its not working again.How can I do this?.What are the best solution for this?
Please somebody help me on this.
I will look forward to your reply.
|
|
|
|