Forms :: Progress Bar In Oracle 10g?
Feb 10, 2011currently i m making a report , on this i want to insert progress bar ....
View 5 Repliescurrently i m making a report , on this i want to insert progress bar ....
View 5 Repliesi have this procedure in my form to make some checks on employee data:
Procedure Pu_Check_Emp_Positions_Prc Is
Cursor vc_get_users_data_case1 Is
Select A.User_No, A.User_Responsility, A.User_Position, B.User_Status
From Import_Emp_Positions_Dtl A,
Shows_Users B
Where A.User_No = B.User_No
And (Substr(A.User_Position, 1, 1) = 'R' Or Substr(A.User_Position, 1, 1) = 'r')
And A.User_Responsility Is Not Null
And B.User_Status In (2, 3, 4, 7, 8);
--And A.User_No = 'XSER0001';
[code]....
i need to run this progress bar and finished when the procedure finish.
How can we include a progress bar in forms?
View 1 Replies View RelatedI have challenge to do progress bar
i have simple form has one database block tabular used to upload files by webutil procedures
my question is there build_in progress bar that special for uploading could be used by webutil ?
Urgently need a code for displaying progressbar on spalsh screen on new form instance without button click
View 1 Replies View RelatedI try to login to my server but got "Login Error: SQL Error State 08004 , Native Error Code : 409 , ODBC Error , [Oracle][ODBC][Ora] ORA-01033 : ORACLE initialization or shutdown in progress".
View 3 Replies View RelatedWhen i tried to connect oracle "oracle initialisation or shutdown in progress" was the error. then i tried the following steps and the results are as detailed below.
C:\>sqlplus/nolog
SQL*Plus: Release 9.0.1.0.1 - Production on Wed Jun 30 12:30:40 2010
© Copyright 2001 Oracle Corporation. All rights reserved.
SQL> connect sys/manager as sysdba
Connected.
SQL> exp
SP2-0042: unknown command "exp" - rest of line ignored.
SQL> export
SP2-0042: unknown command "export" - rest of line ignored.
SQL> shutdown
ORA-01109: database not open
[code]....
i have a Problem when i try to connect to my Database Oracle 10.2.
every time i tried to connect to my database the Message: ORA-01033: ORACLE initialization or shutdown in progress appear.
In the alert.log there is the last writen part:
Wed Feb 16 21:55:54 2011
Errors in file d:\oracle\admin\v8\bdump\v8_arc0_5220.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 102385664 bytes disk space from 21474836480 limit
[code].....
In the morning i still work with my database then it freez and after restart the System i get everytime the same error Message.Start and stop the Oracle Service does not work.My system is Windows XP SP 3 if this is importend.
I am facing with the following error where I can not log into the iSQL*Plus 10.2.0.3.0.
ERROR - ORA-01033: ORACLE initialization or shutdown in progress in oracle 10g.
I am using windows 7 on my 64-bit machine, and I installed oracle database 12c. Everything was installed fine, and i was able to connect to the HR schema. However, the next day when I wanted to connect, I got the ORA-01033 Oracle initialization or shutdown in progress error.
View 10 Replies View RelatedI was installing Oracle 10g Client on my PC. But after Specifying Home Details, I was unable to proceed. The installation hangs in the Loading Product Information form.
The Progress bar stops at 80%.
C:>sqlplus
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Oct 11 09:56:23 2012
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production
SQL> startup nomount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01109: database not open
[code]...
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL>
When I am trying to connect to sql from scott or any other user i am getting this error message ,
ORA-01033: ORACLE initialization or shutdown in progress
I have been getting this error message for 4 four days . Butt when i am trying to connect from SYS user it connects successfully ,but when i do query it gives me following error message .
ORA-01219: database not open: queries allowed on fixed tables/views only
I shutdown Database from SYS user ,and start it again .But at startup it gives me following error message .
ORA-00204: error in reading (block 3, # blocks 8) of control file
ORA-00202: control file: 'D:ORACLEPRODUCT10.2.0ORADATAORCLCONTROL03.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).
when i am using sql prompt and enter username and password scott and tiger it is giving error ORA-01033 oracle initialization or shutdown in progress.
View 9 Replies View RelatedI am getting the error 'ora-01033: Oracle initialization or shutdown in progress' when I try to login into oracle. It was working fine some days ago.I tried the below steps :-
C:Documents and Settingssk32740>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 24 14:31:08 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
[code]....
My database was working fine and now I am not able to login and getting the error:-
"ORA-01033: ORACLE initialization or shutdown in progress"
I have done the below steps:
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORA-32004: obsolete and/or deprecated parameter(s) specified
[code]....
I have a large 10G database, with records being inserted almost constantly. In order to "UPDATE" records, I need to be able to DELETE the old record and INSERT the new record (even while records are being inserted into the table). It appears that DELETES won't work while records are being inserted (1.5 million records per day). Is there a way around this (which I'm assuming at this point is a contention issue)? The INSERT uses the NOPARALLEL hint; no hints on the DELETE.
View 7 Replies View RelatedIs it possible to perform a DML or DDL when a select query is in progress?
View 8 Replies View Relateddb environment: 11g
recovery catalog: 10g
I am trying to find if there is a way to know how much data has been written on tape on a 'in progress' rman backup. rman session is also connected with recovery catalog.
is there a way to find-out how much data is transferred per rman channel onto tape? what is backup speed we are getting?
I am still having issues with my progress bar while loading a heavy popup page(not modal). I got this to work but i came to realize for very fast internet/network environment you cant see the icon at all, the page stays blank for 30secs then loads the data but no icon/progress-bar appears but at least i can see icon very short interval whenever i use wifi / slower connection.
How can i make this progress bar starts immediately i click button to popup the called page? I also tried this plugins 1
[URL].......
but doesn't seem to work,
2)this seems to work for very short interval in slower internet/network connection only==>
templ df header:
<div id="loading" style="display:block;position:fixed;top:0px;left:0;z-index:1999;width:100%;height:100%;background-color:#fff;text-align:center;">
<div style="position:relative;top:130px;">Wait..loading..</div><img src="#WORKSPACE_IMAGES#AnimatedProgressBar.gif" style="position:relative;top:150px;"/></div>
footer:
<script>$(document).ready(function(){ $('#loading').hide()});</script>
in apex 4.1.0x/oracle 11g Enterp.
I want to show progress bar every time when page loads.
Progress bar is coming on the page. but it is not going off after page is loaded.Below is the code which i added for the Progress bar.
//written on Header Text of Page
<script type="text/javascript">
<!--
function html_Submit_Progress(pThis){
$x_Show('AjaxLoading');
window.setTimeout('$s("AjaxLoading",$x("AjaxLoading").innerHTML)', 100);
}
[code]...
I want only to show only page loads.
Apex Version : Apex 4.1
DB Version : 10g
I have oracle 10g as well as oracle 8i on my server. currently we are using oracle 10g. now we get the following error when we try to connect to oracl 10g database.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:Documents and Settingsomni>cd
C:>sqlplus
olog
The system cannot find the path specified.
C:>sqlplus/nolog
SQL*Plus: Release 8.1.5.0.0 - Production on Tue May 15 16:39:13 2012
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> connect sys/admin as sysdba
Connected to an idle instance.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
LRM-00109: could not open parameter file 'D:oro8iDATABASEINIT.ORA'
ORA-01078: failure in processing system parameters
The location of pfile of oracle 10g database is c:/oracle/product/10.0.0.1/admin/pfile.
Query :"how to send mail to lotus notes with attachment from oracle forms"?
View 2 Replies View RelatedI created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.
Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.
I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.
I tried TEXT_IO package.But that is not allowing to access Unix path.
I have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.
So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column. so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.
-more details
I have table with columns id, name, location, address, plan. in those columns i need to insert records form excel. user having a excel with 3 columns col1, col2, col3. on the form i've fetch column headers of excel and in front of that i've provide database column list , so user can match excel column with database column. e.g.
COL1 --> list value of database column
COL2 -->list value of database column
COL3 -->list value of database column
Once user map those column i want to insert those values into my database table (table with columns id, name, location, address, plan). and i am confuse about this code.
i'm using db and forms 10g. i want the output of the form to be embedded within a simple html page. lets say i want the html page to be divided into three frames. the uppermost horizontal frame will hold a banner (say). the left vertical frame will hold some advertisement (say).
(1) now the rest of the page will be covered by the third frame in which the fmx's will run.
(2) i want the login.fmx (startup form) to show up first instead of the servlet. infact the servlet should not show up at all.
Any utility that will take in a string and then search through multiple Oracle Forms and Reports modules (.fmb, .rdf, .mmb, .plx, etc). simultaneously to find which modules have strings that match the search criteria ?
To do this on an individual form is easy enough using the Oracle Forms Developer editor however I have over 100 Forms and reports.
I would like need a utility that will search all Oracle Forms in a given directory without having to actually open a Form(s) in the Oracle Forms Developer editor and then report which Forms may contained the sought after string.
How to Know Operating System Current Path in oracle 10g forms ?
View 4 Replies View Relatedwhen I try to connect my forms 6i with oracle 9i database, forms stop working and closed immediately at the meanwhile tnslsnr also stop working. This problem also persists in forms runtime.
View 6 Replies View Related