Forms :: Creating New Browser Session With 11g
Mar 2, 2011Is there a way to start a new browser session from a call in an existing 11g form. I have a situation where in the client / server world I open a form in a new window .
View 1 Replies
ADVERTISEMENT
SQL & PL/SQL :: Creating A New Session
Mar 14, 2013How to create a new session from a pl/sql. My requirement is that i will package which should run on new session and execute it.
BEGIN
A; --Calling package
B; --Calling package and this should run on new session.
C; --Calling Package
end;
Now when I will run the this plsql block, then A,C should execute will run in this package only but B will run separate session.Whole idea to have better performance. I heard we can use PRGMA AUTONOMOUS_TRANSACTION, but this is not working.
Forms :: Best Browser For Oracle 10g
Jun 20, 2012which is the best browser for oracle 10g forms ?
View 3 Replies View RelatedForms :: Detect Browser Name?
Dec 8, 2010I need to define the type of user's web-browser (Opera, Ie, chrome, firefox), under which launched forms.
View 3 Replies View RelatedForms :: Process ID Of Browser?
Apr 28, 2011I captured the process id of the browser. I wanted to know whether the process id of the browser is dead or not after we close the browser. How can I check the condition for the process id in oracle forms?
View 1 Replies View RelatedForms :: Applet Is Not Opening In Browser
Jul 26, 2011When I click on 'Run Form', the Applet is not opening in Internet Explorer.
Giving Error like " Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience."
Even I have re-installed the oracle 10g the same problem is coming.
Note: When I remove jinitiator and then reinstall jinitiator the applet is opening once and again if I run the form second time the same above error is coming.
Forms :: Supported IE Browser Version For 10g
Oct 9, 2013Currently i am using IE 6 for running my forms 10g, I like to know upto which IE Versions i can update so it must not affect my Oracle forms 10g running.
i like to update to IE 8, but it must not affect my forms runtime functionality!
Forms :: Combo Box Display In Browser
Dec 30, 2010I have a list box that is populated from a record group using a WHEN-NEW-FORM trigger. When I run the form this displays fine when the list box is set as Poplist or Tlist, but when I change this to combo box and run the form it doesn't load properly in the browser (a blank screen followed by the background a a toolbar that says window).
View 3 Replies View RelatedForms :: Why Other Browser Cannot Run Oracle Form Without IE
Oct 9, 2012Why Other Browser cannot run oracle forms without IE.
i want to use other browser for oracle form like firefox,google chrome etc not IE.
Forms :: Set Size Of Window In Browser?
Jan 22, 2013how i can set the size of runtime window in My browser? I have a larg form ( 800 X 600 )
View 1 Replies View RelatedForms :: Raise Alert When Browser Closed In 11g
Feb 27, 2012I am working on Forms [32 Bit] Version 11.1.1.4.0 (Production). OS is Win 7 (32 bit). Internet Explorer 8. My Requirement is I need to raise an alert when user close the browser window before closing the Form.
View 2 Replies View RelatedForms :: 10g Show Empty Screen In Browser?
Jun 29, 2012When I try to run the form by clicking Program/Run form, it opens a webpage(explorer) and displays ?ORACLE FORMS? label, but does not show the form only blank screen appear. When I try to run the form by clicking Program/Run form, it opens a webpage(Firefox), but does not show the form only blank screen appear.
I have noticed that in Start OC4J Instance it has some thing like as below:
SYSDATE TIME FormsServlet init():
configFileName: E:DevSuiteHome_2/forms/server/formsweb.cfg
testMode: false
pop-ups is not blocked in my browser I have allow active content to run in files on your computer.directory name (where the form is stored) also doesn't contain any spaces.
Also I have change the
baseHTMLjinitiator=basejini.htm
to this
baseHTMLjinitiator=basejpi.htm.
I have done all the things mention in this forum to overcome this error.But, still the same problem is there.Also please take a note that I am using JRE not JINITIATOR. Beacuse when I am using the JINITIATOR it give me the problem of browser crash in both IE and firefox.Also I am using Windows XP and oracle form 10g.
Forms :: Internet Explorer 8 Not Working As Browser For 10g?
Mar 1, 2010For all my client machine Internet Explorer 8 is not working. Internet Explorer 7 is working fine . For a machine with Internet Explorer 8 after Installing Mozilla Firefox it's working under Mozilla Firefox Browser well.
View 3 Replies View RelatedForms :: Hide Menu Bar And Tool Bar Of Browser At Run Time?
Mar 30, 2011i want to hide browsers menu bar and tool bar at form run time and i want to show only form menu in the browser
View 2 Replies View RelatedForms :: Conversion - Make It Accessible Based On Browser To Clients?
Jul 6, 2011i have developed an oracle form application in oracle developer 10g, now i want to make it accessible based on a browser to the clients(make it a web aaplication form)
View 3 Replies View RelatedServer Administration :: While Creating Index ORA-00603 / ORACLE Server Session Terminated By Fatal Error
Jul 26, 2010While creating the index we are getting the error "ORA-00603: ORACLE server session terminated by fatal error".
We have the space in tablespaces and also in the file systesm.
Application Express :: Kill Current Session When Another Session With Same User Starts
Nov 19, 2012I have an urgent requirement to kill an existing session if a new session starts for the same user. I have been reading lot of blogs and posts on the above topic, but could clearly tell me how to do it.
I thought of putting a process in 101 page when login button is pressed to catch this and kill the old session.
Application Express :: (X) Process Taking 60% CPU In Two Session (30% Each Session)
Oct 23, 2012We are using Apex 4.0/Oracle 10gR2/ Hp-Ux, We noticed that there is a process Running in Two Sessions that seems running since 3 Hours using 60% CPU,** 30% given below sql it executes in two Sessions!
declare function x return boolean is begin -- if instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY')>0 then
declare
l_position number := 0;
begin
loop
l_position := instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) ;
exit when instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) = 0 ;
[code]....
Grant Select On V$session And Gv$session Directly?
Aug 28, 2013Instead of giving permission directly to v$session and gv$session to a developer, Is there any other way to do the same?
View 3 Replies View RelatedForms :: How To Implement Session Expiration In 6
Apr 20, 2010How I can implement session expiration in form 6.
i.e. if the user is idle for a few minutes, I wish to present a message and then close the application.
Forms :: Possible To Alter A Session Within Oracle Form
Sep 3, 2010Is it possible to alter a session within Oracle forms as I get the following error when trying to compile the following block.
BEGIN
EXECUTE IMMEDIATE ( 'alter session set nls_date_format = 'DD-MON-YYYY''');
END;
Error: Encountered the symbol "IMMEDIATE" when expecting one of the following
The basic requirement is to validate a date field on the form against the current system date, but as the form is in format DD-MON-YYYY and the Database on M/D/YYYY I am struggling to compare dates successfully.
Forms :: Creating A Username And Password In Oracle Forms 6i
Sep 12, 2010I created a form to create a username and password.i tried creating a user in forms 6i using the following code on the when button pressed trigger:
BEGIN
forms_ddl('create user'||:user_name||'identified by'||:pasword);
commit_form;
END;
i have granted the user to create user but it does not work at all. password and user_name are captured in the form.
Forms :: Creating A Procedure Oracle Forms And Database
Nov 3, 2011I am creating a procedure oracle forms and database Which one is fires first ..If suppose i need data base fires first...
View 3 Replies View RelatedForms :: 6i - Expiration Of Session-level Database Of Profiles
May 5, 2010I have an application in Form 6i and I have implemented expiration of Session-level database of profiles, the problem I have is that I do not know in which time expired the session because it shows me no message and the application is open, try to do something and begin to get errors .
View 2 Replies View RelatedForms :: Session Variable Values Overwritten Between Transactions?
May 23, 2011There are 2 people on separate machines each executing a transaction through the same form, processed through a when-button-pressed trigger.The first session processed correctly. For the second user, the session seems to have picked up the non-PACKAGE variables of the first session in what was passed through to the data base. Values associated with the 2nd session's PACKAGE-based types appear to have passed through correctly.
Hence, the second user's transaction processed with a combination of values from the two sessions, with the second user's PACKAGE-based variables merged with the first user's non-PACKAGE variables. There is no use of context variables. There are some global values, but none of them are used in this trigger.The values in question, that appear to have passed from the first session to the second, are based on contextual LOV selection: after selecting a transaction type, users are prompted to select from a LoV specific to that type. Value property set "Validate from List=>Yes".
The 2nd session's PACKAGE-based values do not correlate to the non-PACKAGE values, leading us to conclude that the latter values somehow came through from the first session. We are running IAS 10g R2 on Oracle 10gR2 (10.2.0.3).Each user session is created as user logs into the application and hence logically there should not be any overlap between sessions of different users concurrently.
I did have a look at the code and predict nothin wrong with the source code since the system has been in use for a few years now and only occurred a couple of times in last few months. Also one more noticeable thing is that the issue is not reproducible. I would believe somethin goin wrong in the middle tear or with the session management. Are there any known issues in session management in the Forms server Or something?
Forms :: Killing Inactive Session Through Oracle Application Server
Mar 5, 2013I am trying use host command in Oracle forms. I get the process id as input from the user and on clicking ok the form should kill the session related to process id.
PS: Users will be entering only frmweb.exe process id which are inactive.
cmd := 'CMD /C taskkill /F /FI /pid 'process which is got as input' /IM frmweb.exe'; host(cmd)I also tried by writing the above command into a .bat file in application server.When trying to execute the bat file it din work. But when tryin to run the bat file by double clicking in Application server the session was killed.
On executing the above I am unable to kill the process. I would also like to know whether the host command was successful or not. Orakill and alter session are working but I don want to use it.
XE :: Can't Access Database 11g EE In Browser?
Aug 25, 2013Database 11g Enterprise Edition.
Probably if I give the installation procedure I went through and specified Error messages,. Installation Option: - Create and configure database was selectedSystem Class: -Sever Class was selected Install Product:-Oracle Database Installation= Succeeded· Prepare= Succeeded· Copy files= Succeeded· Setup files= SucceededOracle database configuration= Succeeded· Oracle Net Configuration Assistant=Succeeded· Oracle database configuration Assistant=Ignored· Oracle configuration Manager Configuration (optional)=Succeeded In the process of the Install Product the following Error messages
[code]....
Dba-tab - Can't See Any Histogram On TAB 1 In Schema Browser?
Jun 13, 2013If a table and several columns are listed in dba_tab_histograms does this mean that the table 100% certain has a histogram or more?
select * from dba_tab_histogramsAND table_name='tab1';
OWNER TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_ACTUAL_VALUE
---------- ------------------------------ ------------------------- --------------- -------------- --------------------------------------------------
USR TAB1 COL1 0 3.0002E+
USR TAB1 COL1 0 5.0661E+35
USR TAB1 COL1 0 200062635
USR TAB1 COL1 0 2456436.95
USR TAB1 COL1 1 1.1002E+10
USR TAB1 COL1 1 2.3720E+35
USR TAB1 COL1 1 230082138
USR TAB1 COL1 1 1236436.95
In Toad I can't see any historgram on TAB1 in the schema browser.. Running Oracle 11.2 on Linux.. Question:If a table with columns are "in" dba_tab_historgarms does this actually mean that there are a histogram on the tables/column?
Enterprise Manager :: Connect To Database Through Web Browser?
Nov 11, 2011I am Not able to connect to the Database through the web Browser,
I have started Listener, EM, and i have checked the port number is in Listen mode all is working but not connecting to the EM through web browser.
Creating A User Through Forms 6i?
Sep 12, 2010I created a form that would allow a user to create another user.i tried creating a user in forms 6i using the following code on the when button pressed:
BEGIN
forms_ddl('create user'||:user_name||'identified by'||:pasword);
commit_form;
END;
pasword and user_name are captured in the form.