Forms :: Get Client IP Address When Initializing Forms
Jun 25, 2010
How 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
how 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 ?
I have created oracle 11 XE..Once it is created it was running fine.I have worked on that 2 days.
Problem is occured when I restart my machine.I m getting below error:
Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
I have checked the forum in which it is mentioned that ORACLE_HOME is not properly set.I tried that one alot of time.Even now environment variable shows proper value.
My 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);
i 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;
On cliente/server, I used to get the user IP address using SYS_CONTEXT and IP_ADDRESS, and the terminal name with SYS_CONTEXT and HOST.But in web environment, these functions returned Server IP and name.I have to build a trigger to obtain the information of user IP address and terminal name to save on audit table.
How to grep client's IP address when LOGON to database? I write a trigger , but when compile , it show Error , Here is code :
CREATE OR REPLACE TRIGGER On_Logon AFTER LOGON ON The_user.Schema DECLARE v_addr VARCHAR2(11); BEGIN IF (ora_sysevent = 'LOGON') THEN v_addr := ora_client_ip_address; raise_application_error( '-20001', 'user IP: '||v_addr); END IF; END; [code]....
I want to export forms data into Excel sheetfor that i am using Client_Ole2.I have attached Webutil object library and Pl/Sql libraryStill I can not export data from Form to Excel sheet
I 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.
I have to design a database so that the performance is optimum and joins are optimum between tables.
Requirement - I have several banks as clients globally, like HSBC, RBS, AMEX etc. Each bank operate globally, and are divided like the geographies, regions etc. For eg. HSBC is operating from US, UK, ASIA, AUSTRALIA. Each geoagraphy is further divided/childs, like, in ASIA has INDIA, PAKISTAN, SRI LANKA, CHINA. Further, it is divided, like in India, it has cities like DELHI, BOMBAY, CHENNAI etc., then further it has within Delhi - Lajpat Nagar, Rohini, Pashim Vihar etc.
As per the above scenario, I need to store addresses, phone numbers, of all the branches of all clients. Also, there is one more condition like in the above defined hierarchy, later on, a new hierarchy can be added, like In INDIA, it can further divided in States and then its local cities.
running CENTOS 6 and oracle DB 11.2.0 and when i try to launch sqlplus i get the following error:
Error 6 initializing SQL*Plus SP2-0667: Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
problem is, it's telling me to set ORACLE_HOME but I'm not sure where this is to set.
Oracle developer suite 10g i am installing 10 developer in server can you explain me how to run client side forms and report web-throw witch address i tel him to client.
I run into i bug of a 10.2.0.3 database which crashes with older versions of oracle clients (<8.1.7) . I´m running forms 6i patch 4 and want to use e newer client. Is it possible to upgrade the original client?
I just installed WEBLOGIC server on linux with oracle forms 11g builder and report builder on the server.
On the client machine , i have probleme to intsall oracle forms 11g , in one of the steps it asks me to enter the absolute location of server weblogic , i enter the location of the weblogic on the server , but it dosent' work. is it mean that i have to install the weblogic on the client machine too!! if not to install forms builder 11g on the client
I have a form that upload an excel file to the database . I make for in it a browsing button for the uploaded file and take the path (e.g c:upload.xls) when the procedure of upload work. it always search for the path on the application server and thats wrong . I want it to search on the client machine for that path .
PROCEDURE XLS IS BEGIN DECLARE application OLE2.OBJ_TYPE; workbooks OLE2.OBJ_TYPE; workbook OLE2.OBJ_TYPE; worksheets OLE2.OBJ_TYPE; worksheet OLE2.OBJ_TYPE; cell OLE2.OBJ_TYPE; args OLE2.OBJ_TYPE; [code]........
you see this
filename := :block7.FILE_NAME; (5th line from the begin block) :block7.FILE_NAME is the path that i said as an example c:upload
That path is on the client machine the form trying to open that path from the application server.
I am doing some work in Banner (the SCT Sungard ERP for educational institutions) and am attempting to use TOAD to debug a PL/SQL web form.
Everything that I've come across thus far indicates that I need to enable debugging, attach the package in TOAD to the external session using Debug > Attach External Session, and then call the web package [URL].
Here are the steps I have followed thus far:
1. Execute the following anonymous block via a SQL window in TOAD to get the debug session ready (I don't have SQL *Plus installed, so I did it from a SQL window instead)
DECLARE id VARCHAR2(255); BEGIN id := DBMS_DEBUG.INITIALIZE('PABLO_TEST_DEBUG'); DBMS_DEBUG.DEBUG_ON; END;
2. Load the package/procedure I want to debug into a pl/sql window in TOAD and set a breakpoint.
3. Select 'Debug > Attach To External Session', and enter 'PABLO_TEST_DEBUG', which I earlier defined as the debug session id.
At this point Toad just spun its wheels for about five minutes, and then a probe query timeout error was received.
On a subsequent attempt executing the anonymous block simply resulted in the query executing for over 20 minutes, at which point I canceled execution. I'm using TOAD for my development environment, and it's essential that I can get decent debug information.
Given the depth and complexity of the system I am working in (Banner from SCT Sungard), it is incredibly inefficient to have to insert calls to htp.p to find out where the problem is. This has, at times, resulted in a few hours of testing to track down a problem that with a proper debugging environment would be identified almost instantly.
how to enable debugging within TOAD of pl/sql packages/procedures/functions that are called via the web.
When I try to download file from client to server a found the following error./oas/product/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar.
