Forms :: How To Use Static IP Address In Oracle 10g
Jun 4, 2011how to use static ip address in oracle 10g.
View 5 Replies
ADVERTISEMENT
PL/SQL :: Static Table Creation In Oracle - Difference Between Static And Dynamic Table
Dec 11, 2012Static Tables Creation In oracle & Diff Between Static table ,Dynamic table
View 2 Replies View RelatedNetworking And Gateways :: Oracle Forms 6i Call Form Via Static IP?
Sep 6, 2011I 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?.
Forms :: Get Client IP Address And Machine Name In Oracle 10g Without Webutil
Sep 26, 2013How can we get client ip address and machine name in oralce forms 10g without webutil.
View 3 Replies View RelatedForms :: How To Connect Database With Static IP
Jun 4, 2011i got static ip from witribe a broadband company in pakistan i am trying to connect database from client side computer who connect with internet when i ping my server it reply with good speed but when i try to connect database the message appear (Unable to connect Destination) but it works very well with Local Area Network computers. More how can we change port 1521 in client sides
View 6 Replies View RelatedSQL & PL/SQL :: Static Variable In Oracle
May 10, 2011Can we declare static variable in Oracle 9i.
View 2 Replies View RelatedForms :: Access File From Server Via Static IP At Outside LAN
Jul 4, 2011I am using oracle 9i release 2 and forms 6i.I have a question,I have stored all the fmx files under one folder in a single server called "MAINSERVER".From here only client system calls the forms.In am calling forms in call_form function like
call_form('\MAINSERVERFORMSemployee.fmx',no_hide);
here mainserver is the server name, forms is the folder name and employee is the form name in fmx format.My question is when i call form from server with in a network no problem but When i call form from outside lan that through internet via static ip forms are not called.I tried like this way call_form('\198.52.67.66FORMSemployee.fmx',no_hide).Here i have specified static ip and forms folder but is not working.
Networking And Gateways :: Oracle Database Not Connect From Outside LAN Via Static IP
Nov 17, 2011I have created two database one for production and another one for test.I created both database in shared_server mode(by using dbca),after than I did not change anything.My problem is when i connect to test database from outside lan through static ip its working well,but when i connect to production database which is not connected. I checked and compared two databases,then I find there are some changes in dispatcher and mts_ dispatcher parameters.And I used this query to check the shared_server status,
ie.select * from v$shared_server,
the output of this query is attached with this post.
SQL & PL/SQL :: Display Office Address / House Address And Emp ID In Single Query?
Feb 23, 2013I have two tables emp , emp address as below
emp table :
emp_id emp_name,
1 rajesh
2 suresh
emp address table :
emp id emp_addresstype emp address
1 O kukatpally
1 H Hitech
2 O Kolkata
2 H hydar nagar
I need the query to display the Office address & House address & emp id in single query
ex: 1,Kukatally,hitech
2,kolkata,hydarnagr
Forms :: How To Get IP Address In 6i
Dec 31, 2012How to get ip address in forms 6i ?
View 6 Replies View RelatedForms :: How To Get Client IP Address
Feb 15, 2010method to get the ip address of Client machine using oracle forms .
I am using Oracle forms 6i and application server 9i.
Forms :: Get Client IP Address Using 10g Rel.2?
May 2, 2011how i can get Client IP address using Forms 10g Rel.2 and if other useful information i can get, how is it possible? is there any other solution if not using WebUtils ?
View 2 Replies View RelatedForms :: How To Get User IP Address
Jun 13, 2012I'm trying to get client IP Address and show it to the user. I'm using forms 10g, with application server under UNIX.
View 1 Replies View RelatedForms :: IP Address Validation
Feb 18, 2007Has any one written the validation code for
IP Address...
i.e it should be any thing from 0.0.0.0 to 255.255.255.255
Forms :: Get Client IP Address When Initializing Forms
Jun 25, 2010How to get the client machine IP in Forms 10g without using webutil? I know the function Webutil_clientinfo.get_ip_address. But Webutil is not working in when new form instance. And I need get client ip address in trigger PRE-FORM.
sys_context('userenv', 'IP_ADDRESS') return address of server, not client.
OR
How to make the trigger WHEN-CUSTOM-ITEM-EVENT in Webutil starts before triggers "WHEN-NEW-FORM-INSTANCE" and "PRE-FORM" ?? To use webutil_ clientinfo.get_ip_address
Getting Name In Email Address (Oracle SQL Plus)
Nov 6, 2007How do I select the name in an email address. I would like to be able to order a list of email addresses by the name of the person ie. what comes before the @ sign.
So is there a query I could use to get everything before the at line . So in pseudocode I would need to be able to do something like this.
select substr(email, indexOf(@)+1,email.length) from table order by email
So I how could I go about doing that?
SQL & PL/SQL :: Mac Address Finding Using Oracle
Sep 26, 2011we can find the IP address in V$session table. Is it possible to find the mac address of user's computer?
View 13 Replies View RelatedPL/SQL :: Oracle 9i - How To Construct Address
Apr 17, 2013I'm using Oracle 9i. I want to make an address: city, state zip.
However, if there is no city or state, I don't want the comma. Doing this in decode made my head swim, so I went to case. I think that I mapped it out well, but I cannot have the variable on each section. This is my currently incorrect code.
CASE WHEN LENGTH(TRIM(AG.CITY)) = 0
THEN ST1.CODE || ' ' || AG.POSTAL_CODE
ELSE WHEN LENGTH(TRIM(ST1.CODE)) = 0
THEN AG.CITY || ' ' || AG.POSTAL_CODE
ELSE AG.CITY || ', ' || ST1.CODE || ' ' || AG.POSTAL_CODE
END ATTY_CITY_STATE_ZIPI'm trying to stick the end-product into ATTY_CITY_STATE_ZIP.
Forms :: Using Webutil To Get IP Address On Form Load
Feb 12, 2008My requirement is to show the ip address of the client after he has logged in.
I tried putting the code in when-new-form-instance .. but it returns null. I think the webutil objects are not yet loaded in when the when-new-form-instance is fired. If I put the same code in a push button , I am able to get the IP address. Actually for test purpose I am displaying the IP in a message.
Message ('Client IP add '|| webutil_clientinfo.get_ip_address);
Forms :: Declare Message For @ Is Not Type In Email Address
Oct 24, 2011i want if user is not type the @ in email text box than from show the message "check your email address" but i cant do that
declare
ok_flag number :=0;
begin
ok_flag :=instr('emailaddress','@');
if
ok_flag < 1 then
message('invalid email');
else
message('thanks');
end if;
end;
Oracle 11g Client / ORA-12533 Illegal ADDRESS Parameter
Jul 10, 2011I am working on a database application which works as a data access layer. The application uses OCI interface to connect and query to the Oracle Database. This application is certified on Oracle 9i and 10g client and works fine without any issue, but when I am certifying the application on Oracle 11g client, I am getting connection failed problem and following Oracle Error is displayed.
ORA-12533 illegal ADDRESS Parameter.
There is no change in the environment setting between Oracle 10g and Oracle 11g.
Following are the details of the environment
Version of Oracle 11g client is 11.1.0.6.0
Version of Oracle Database is 11.1.0.6.0.
Platform - Solaris 5.9 on sparc v9
On enabling client trace with support level also does not work. It shows TNS error TNS-12533 illegal ADDRESS Parameter.
what could be the possible reasons that the connection is failing with Oracle 11g client, while the same is working with Oracle 10g client. As I said there is no environmental difference when performing this test. The only change is ORACLE_HOME setting for the corresponding Oracle client version.
Security :: How To Find User And IP Address From Oracle Database
Jun 19, 2013Last week we have realized that a user who connects through SQL Developer(as nothing wrong found in application server logs) has made a serious change in the database which created a real mess. The user has done some mischief in some calculations by making some inserts and updates in some important tables in our production database.
How can I find which user or from which IP the change is made.
Server Administration :: Install Oracle 11g On Windows 7 - Just IP Address Available
Jan 17, 2013With just the ip address available, how to install the oracle 11g software on windows 7? What are the access I will need in order to Install the oracle 11g software and create the oracle 11g database on windows 7?
View 7 Replies View RelatedConnection String To Connect Remote Oracle DB Using IP Address
Jul 23, 2012I have sample windows C# application to connect remote Oracle DB(Enterprise edition SQ L plus).
Want to connect remotely without installing oracle client on local system.
Server Administration :: IP Address / Host Name Or Domain Of Oracle Database Servers
Mar 27, 2012Due to some some Network issues . we have planing to move oracle database one domain to another domain changing domain name and IP address of oracle database . if want to change oracle database 10g(10.2.0.5.0) 32 bit windows version what are setting s to change in oracle database.
View 3 Replies View RelatedForms :: Get IP Address From JSP In Forms?
Jul 12, 2010novice get IP address from the JSP in Forms?I found some sample
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ExtractRemoteAddr extends HttpServlet
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
[code]...
I can not find information, how can this java code to use in Forms. And how to get this Remoute address. There are people in the know?
Services Not Registered With Static Listener?
Jun 11, 2013what configurations I do the static listener shows no services.Here is my listener.ora
:SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME=ELLISON9) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=ELLISON9) ) ) LISTENER11G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora1)(PORT = 1522)) )ADR_BASE_LISTENER = /u01/app/oracle My tnsnames.ora:ELLISON9 =
[code]...
How To Show Image On Report But Not Static Filename
Oct 22, 2004I am using Reports6i. I want to know how to show the image on the report but the image is not in static filename.
I used "Link File", but the "Source Filename" Boilerplate can only allow me hardcode the file path and file name.
Remark: The image is not stored in the database.
PL/SQL :: Only Display A Column Value One Time For A Record / Not A Static Value
Jan 7, 2013I am trying to only display a column value one time for a record, not a static value. The value changes and there can be many values. I do not think grouping will work since the Date value is dynamic. I am using Oracle for Toad 10.5. There are 4 records with this test data.
select Date, Person, Language, Country
from TableATableA
Date Person Language Country
01/25/2013 James English
12/20/2012 James English
US
[code]....
Application Express :: Possible Bug In Export Of Static Files In V4.1.1.00.23
Jun 8, 2012We recently updated to version 4.1.1.00.23, and need to do an export of our static files to migrate from our development to test (ApEx run-time) platform. When our DBA attempted to run the export script (we had renamed it from static_file.sql to browser_detect.sql), he received this error:
SQL> @browser_detect.sql
Set Credentials...
Check Compatibility...
Set Application ID...
...static file repository
p_notes=> '');
*
ERROR at line 14:
ORA-06550: line 14, column 5:
PLS-00103: Encountered the symbol "P_NOTES"
when expecting one of the following:
. ( ) , * % & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "(" was substituted for "P_NOTES" to continue.
ORA-06550: line 14, column 18:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
. ( ) , * % & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset
We took a look at static_file.sql, and noticed this:
declare
l_name varchar2(255);
l_html_id number := null;
begin
l_name := 'browser_detect.js';
wwv_flow_html_api.remove_html(
[code].......
The comma is missing after the p_flow_id parameter. This appears to be a bug in the export. It appears to be happening pretty consistently (other static files for this application, other static files for other existing applications).
I did a search of the forum to see if this issue reported this and checked listing on OTN and I don't see any reference to this particular issue. We're hesitant to just add the comma right now since we don't know whether there may be any other issues in the file it's generating.