how can I get the form hostname that it is currently running to? I already tried the form's (forms developer 6i) built in host functionality but it doesn't return the hostname.
Our current approach is to have a shell script that will get and insert the hostname into the table and the form will just query from the table to get the hostname, but that approach has involved too many modules.
Is there an easiest way to get the hostname?
I have a staging which connects to RAC clusters via dblink..I have a scenario to collect the hostname,systimestamp whenever i do a query from this rac clusters
So in general below would be cool
select UTL_INADDR.GET_HOST_NAME,sysdate,x,y,z from gv$symmetric would work perfect
But on dblink..
select UTL_INADDR.GET_HOST_NAME,sysdate,x,y,z from gv$symmetric@dblink.is returning local timestamp and hostname which is not intended
So i even tried subquery..
select (select host_name,systimestamp from v$instance),t UTL_INADDR.GET_HOST_NAME,sysdate,x,y,z from gv$symmetric@dblink
this would work in certain case ...But it certain cases it would throw an error saying mutiple rows from asubquery .All ineed is to get hostname,systimestamp append to all sql i fetch from any this rac clusters through this dblinks.
What is the difference between the following . In my schema all are giving the same results with some different format
SQL> SELECT sysdate , current_date , current_timestamp , localtimestamp from dual;
SYSDATE CURRENT_DATE CURRENT_TIMESTAMP LOCALTIMESTAMP
----------- ------------ ------------------------------------------------- -------------------------------------------------
5/30/2012 8 5/30/2012 8: 30-MAY-12 08.27.22.037703 AM -04:00 30-MAY-12 08.27.22.037703 AM
I need to verify if the current date is grater than the 15th of the current month. If its grater than the 15th of the current month i need to do an action or if else its lesser than 15th of the current month i need to do an other operation.
View 5 Replies View RelatedI have purchased LIVE IP on my application server to access it anywhere on the internet.I am calling application on the internet as URL>...And its working perfectly.
I have configured Sigle Sign On and using this code on "When-Button-Pressed" to call report
WEB.show_document('/reports/rwservlet?server='||:PARAMETER.reps
||'&ssoconn=default/oracledb/userid'
||'&report='||repid
||'&desformat=PDF'
||'&destype=CACHE'
||'&pyear='||:PARAMETER.pyear
||'&branch='||:PARAMETER.branch_id
||'&bk='||:transactions.book
||'&sno='||:transactions.srno
||'¶mform=no'
,'_blank');
From Client side When i press button "sigle sign on authentication page" of Internet Directory is not coming. Because URL is accessing the application server using the HOSTNAME of application server instead of IP ADDRESS like this URL....
How can i configure it to use only IP address.
Is it possible to change the Hostname/IP's nodes on installed GI11.2.0.3? Exist some notes for do this action on "GI standalone" but no for GI.
View 4 Replies View RelatedI've got a oracle install [non production, but devel] that is a tad screwed up. We moved the box and as a result changed the hostname to match the new naming scheme. Ever since then OracleEM has been somewhat confused. In anycase, I don't want OEM anyways now. Plan is to learn SQLplus.
That being said I've used emctl to shut down dbconsole, but it seems there is something somewhere that keeps restarting 2 processes that like to sit around and take up 100% cpu. I can kill them, they stay dead for a few hours then crop up again.I was able to find this out about them:
[jmacdonald@devoracle ~]$ ps auxwww|grep 2033
oracle 20334 84.1 12.3 994052 255824 ? Rs Aug10 1740:43 ora_j000_orcl
oracle 20336 80.9 14.1 998140 294288 ? Ss Aug10 1674:18 ora_j001_orcl
And then this, which caused me to conlucde its OracleEM:
SELECT sess.process, sess.status, sess.username, sess.schemaname, sql.sql_text
FROM v$session sess,
v$sql sql
WHERE sql.sql_id(+) = sess.sql_id
AND sess.process in (20334,20336)
[code]...
How to Know Operating System Current Path in oracle 10g forms ?
View 4 Replies View RelatedHow I can find the hostname for an oracle session id?
View 4 Replies View Relatedi got to find out the users hostname who are connecting to database through remote,i tried with v$session bt it is showing null values in the terminal column.how to find out ?
View 8 Replies View RelatedI have problem about displaying current records with same table(tbl_pawnitem). I have 2 transactions which are the pawned transaction and for sale transaction. and both transactions save into tbl_pawnitem table..i want to display only in my list the for sale transaction without deleting the records of pawned transaction. what condition i will use?
View 5 Replies View RelatedA form has date of birth column.
Date of birth should be displayed according to current month.
Example:
01-jan-1980
01-feb-1975
01-mar-1970
Required:
Let current month is feb then
01-feb-1975
01-mar-1970
01-jan-1980
What should be done?
set the current record indicator for my tabular data block.
View 1 Replies View RelatedHow to focus on current record in oracle forms.
for ex:- I have 10 records in line level.i want to focus my cursor on particular like (5th record) how to possible in form.
Is there any built-in like current_record?
I have master-detail form I would like to update the emp1 table on the base of current value of dept table deptno and emp table ename .
update emp1
set ename = :emp.ename
where ename =
(select ename from emp e
where e.ename=:emp.ename
and e.deptno=:dept.deptno);
I try the above query but it did not able to update emp1 table.
In my form line level block contains 100 records.i will check the check box for line number 96 and 97. Then i will press save(I have written some logic here) button it will generate one number for selected check boxes. After generating this number cursor(control) should be on same line number 96 or 97.
View 10 Replies View RelatedHow can i get the Current user log in on my system using global variable.
View 6 Replies View RelatedI have one tabular block on the canvas and there is one check box on this block. I want that when I uncheck this checkbox, one item on the current record gets disabled.
i manage to turn all the records enabled or disabled.
I am attaching a dummy form in which I have tried. Checkbox is acting on field :ecc_no.
The DB table for the same is:
CREATE TABLE ECC_MASTER
(
PARTY_TYPE CHAR(1 BYTE) NOT NULL,
PARTY_CODE CHAR(5 BYTE) NOT NULL,
ECC_NO VARCHAR2(25 BYTE) NOT NULL,
RANGE_DIVISION VARCHAR2(30 BYTE),
EMP_NO NUMBER(4) NOT NULL,
[code]....
I am looking for a possibility to get the current language from Firefox and/or Internet Explorer.
I searched through the Mozilla Developer Center but could not find an interface to realize that. For IE I also didn't find anything.
I know that IE adapts the current system language from the OS, but can I readout this value?
How to get the label (not value) of current selection in a List Item.
View 7 Replies View Relatedmy problem is this that i have developed a form.fmb in 6i for images scanning direct from scanner but its generating error something like that "FRM-41344 OLE not defined for SCAN in the current record"
li have a winxp enviroment i have already downloaded and installed "IMAGING FOR WINDOW"(GLOBAL 360) but despite this its not working same error is still there .
one more thing why imgscan.ocx is not registering in winxp.
I want to get current mouse cursor position dynamically,what should i do.
View 3 Replies View RelatedI have one requirement i.e i want to make a particular item as mandatory for the current record in the tabular form.
so i have written code as below:
DECLARE
lv_item item;
BEGIN
lv_item := FIND_ITEM ('XXMZ_DETAIL.QTY_ACT');
SET_ITEM_INSTANCE_PROPERTY (lv_item,
current_record,
required,
property_true);
END;
This code is not effecting qty field. If i write set_item_property built-in that item becomes mandatory.But it's not effecting at current record level.It's effecting block level.
So how can i make a field as mandatory at current record level?
I need to copy some text value in to a multi-line text item on the current cursor position.
View 8 Replies View Relatedi m using oracle 10g 10.2.0.2 version.i create a form and using check box on this form.when i click this check box then loop is using behind it.and current cursor is going to last record
i want if i click 4 record then cursor is still showing on 4 record mean i click which record after using loopmy current cursor is showing on that particular record
how it is possible
I have a form with multiple tabs, each tab showing one data block. Many of the blocks are standard in enter-query mode. I want to allow the users to navigate through the tabs while the blocks are in enter-query mode.how can i do this?
View 3 Replies View RelatedI got the following scenario.
- A Master/Detail form which is called from previously saved table.
- In the detail form, user is allowed to insert list of data from other block into the current detail form. For that I have one when_button_pressed with the following script define :-
Begin
go_block('ACT_VW_QT_ACTV'); <----- query block
FIRST_RECORD;
IF :BLOCK44.ITEM45 IS NOT NULL THEN
:BLOCK44.ITEM45:=:BLOCK44.ITEM45|| ' OR ';
END IF;
[code].......
When this is none, nothing being happened on the current block ( 'ACT_QT_TXN1'), I think it is because of the master/detail link where it always looks back the original link data. I think this is very common problem but I just can't figure out how to go about it.
I want to change the current visual attribute color of my form at the application level, reason being i don't want to generate all the forms again from scratch.I know that we can change this using visual attributes but is there a way to change this through some form setting?(Oracle 10g)
View 3 Replies View RelatedI have an employee table that has a paygrp_id that will be used for my subset of employees. For all the employees that have the paygrp_id = 10212 on the employee table I need to update the workbrain_user table to set the flag wbu_cansee_self to 'N'. The join between the employee table and the workbrain_user table is the emp_id.I get the following error when I run this cursor.
[error]
Error on line 0
DECLARE
CURSOR wbuFlag_cur
IS SELECT e.emp_fullname, e.paygrp_id,wbu.WBU_CANS
[code]...
I have a procedure like below:
create or replace procedure sp_test
is
vs_proc_name varchar2(40);
begin
--get the name of current procedure ,here is "sp_test"
--[color=red]but ,i do not want the hard code here[/color]
insert into test_Page(proc) values(vs_proc_name);
---
--
commit;
end;
I don't want to coding like this:
vs_proc_name:='sp_test';
so ,is there any building function to get that ?
