Forms :: Progress Bar Not Working
Dec 11, 2011
i 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.
View 7 Replies
ADVERTISEMENT
Oct 11, 2012
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>
View 8 Replies
View Related
Feb 10, 2011
currently i m making a report , on this i want to insert progress bar ....
View 5 Replies
View Related
Jun 4, 2010
How can we include a progress bar in forms?
View 1 Replies
View Related
Mar 13, 2010
I 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 ?
View 1 Replies
View Related
Jun 18, 2010
Urgently need a code for displaying progressbar on spalsh screen on new form instance without button click
View 1 Replies
View Related
May 28, 2010
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
View 7 Replies
View Related
Apr 1, 2013
Below is the sample code working fine in 10g and not working now in 11g.
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS
import java.sql.SQLData;
import java.sql.SQLException;
import java.sql.SQLInput;
import java.sql.SQLOutput;
import java.util.List;
[code]....
we got the below error: ORA-00932: inconsistent datatypes: expected an IN argument at position 1 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class
Current Oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit and the version we are upgrading is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
View 3 Replies
View Related
Aug 6, 2013
I am developing a form using Forms [32 Bit] Version 6.0.8.11.3 (Production). In my custom form I have given a Push_Button and my idea is to invoke a File open diaglog box when I hit the button.
So, i wrote the below code under 'when-button pressed ' triger. But, the button is not invoking the File Open diaglog box in TEST environment.
=====
DECLARE
XXFILENAME VARCHAR2(50);
BEGIN
XXFILENAME := get_file_name('C:', NULL,
file_filter=> 'JPEG Image (*.JPG,*.JPEG,*.JPE,*.JFIF)|*.JPG|Bitmap Image (*.bmp)|*.bmp|GIF Image (*.GIF)|*.GIF|TIFF Files (*.tif)|*.tif|All Files (*.*)|*.*|');
END;
View 7 Replies
View Related
Feb 1, 2012
I hab a button:
flag:=show_lov('lov16');
if :block.cliente_no is not null then
go_block('clientes');
execute_query;
go_item('block.codigo');
end if;
it calls a LOV and return a value to :block.cliente_no, then execute a query in block clientes, but cursor doesn`t goes to block.codigo it remains in the button ! Why doesn`t works ? Note: if I insert a message before line go_item('block.codigo'); cursor goes to 'block.codigo' (message('hallo');
View 3 Replies
View Related
Oct 2, 2013
i follow the below steps but the calendar lov and button are not shown
1- Go to property pallet of an item set "Subclass Information" TEXT_ITEM_DATE
2- In the field properties, under LOV, set Enable List lamp to Yes
3- Set Validate from List to No
4- Create a Trigger "key-list-val" at item level, code the following: calendar.show
5- Compile it and save
View 11 Replies
View Related
Sep 18, 2012
In a Entry Screen I Require to Check the Value is Changed or not in a Block (A).
If the Value is Changed then Require to done some validation in another block (B) for take the final entry date and their after going to another Block (C), here user require to enter Some data in it.
I am Using the When Timer Expired in the Block (A) for Check the Value and Going Another block, it working till going another after complete the entry Block (C) I have using a Button for move to Main Block (A), but it not going to the consign block and then i put the Message in it, the message is showing, but not going to the block.
View 1 Replies
View Related
Oct 14, 2010
.fmb file why this populate lov is not working
View 9 Replies
View Related
Oct 11, 2011
I 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 Related
Jun 30, 2010
When 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]....
View 2 Replies
View Related
Jan 20, 2012
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 Related
Aug 27, 2012
Is it possible to perform a DML or DDL when a select query is in progress?
View 8 Replies
View Related
Sep 5, 2010
why when-mouse move,up,enter,leave are not working in oracle forms 10g except when-mouse-click and when-mouse-doubleclick on any items.
what i need to do to execute this triggers..
View 3 Replies
View Related
May 9, 2011
i have insert image using webutil (oracle forms 10g) to database in windows o.s. it was successful. but when i have tried it in solaris o.s. . It is not working in linux how to do it in solaris o.s. when i am clicking on the browse button it is showing pl/sql error how to solve it.
View 3 Replies
View Related
Mar 22, 2010
I manage to configure webutil set up on my local pc, jacob jar is working and I can now export data to excel file.
There's a server dedicated to me on linux. I tried to test my form server. There's no error on webutil but the process stops on the line where excel is called. This is the same problem I encountered when jacob.jar is not working on my local drive.
View 2 Replies
View Related
Jan 9, 2012
'm using go_item to open the canvas but the cursor doesnt want to focus on the item. I have to mouse click the item before I can enter any data or tab through it.
View 16 Replies
View Related
Dec 27, 2012
why function keys are not working in forms9i?
Like whenever I press F7 for query or F8 to fetch records or F10 to save records they are not functioning.
View 2 Replies
View Related
Jan 28, 2011
I want to dynamically populate a list item such that the item list should show the name and its value should enter in the background.
I have tried by writing a query in record group, populated it. the list is showing the name in a list item which is not database item. On this List I have written a trigger which is fetching the value to another text item. It is working well but I am not convinced by this method.
for reference, i want if customer select A then list should show balanced and its value is 1when B then list should show lag,lead,advanced... values 2,3,4,.. respectively.
View 3 Replies
View Related
Aug 20, 2010
whenever i double-click on the Canvass node of Forms builder, it displays the "Working..." status on the lower left corner, then after a minute or so, the following message appears:
--
"Oracle Forms Designer has encountered a problem and needs to close. We are sorry for the inconvenience.If you where in the middle of something, the information you were working on might be lost.
Send Error Report / Don't Send"
--
after clicking on the Don't Send button, the builder will close down. i just installed oracle 10g (10.2.0.1.0) database and 6i developer which i downloaded from oracle website.
View 2 Replies
View Related
Mar 22, 2013
I have two tables : oa_membership_dtl(in this created_by field is varchar2(200 byte) ,oa_partner_usr_dtl(in this table partner_userid is number(8,0) i need to do join on above fields.
I am using following two queries:
select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on to_char(partner_user.partner_userid,'9999')=membership.created_by
select * from oa_membership_dtl membership
join oa_partner_usr_dtl partner_user
on rtrim(ltrim(partner_user.partner_userid||' '))=rtrim(ltrim(membership.created_by))
by using first data is not fetched but 2nd is working fine , i am getting the matched records using 2nd query.
whats the diff between to_char and || symbol?
View 1 Replies
View Related
Feb 16, 2011
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.
View 4 Replies
View Related
Sep 22, 2011
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.
View 1 Replies
View Related
Apr 8, 2009
i have created a tree hierarchy....when the user clicks on any node,that particular form will open....But there is some problem...i click on form A,it opens.,...then i exit that form via a exit button on the toolbar....and then I click on form B on the tree....but first the form A only opens...and then again i exit form A, then form B will open..
i have written the following code in when_tree_node_selected trigger :
if condition then
call_form(path,no_hide,do_replace);
View 3 Replies
View Related
Mar 1, 2010
For 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 Related
Oct 3, 2012
i am facing a problem in functionality of a form as there are different search parameters:
date from: text item-->mandatory
date to: text item---->mandatory
house type: list item-->optional
form_status: list item->optional
order by: list item---->optinal
untill i don't select house type by list item everything is working fine and gives desired result, even with house type if i select any house type result is fine but as i select last list item of house type which is null as i want result without house type then it gives no any data as data is present in database.
for example:
date from: 20-05-2009
date to: 21-05-2009
with these two i got the correct result, then i select
house type: 3
i got the correct result and when i change list item to any value like: 1,2,3.....it is working fine but as i want result without house type by selecting the null value in list item as:
date from: 20-05-2009
date to: 21-05-2009
it is not picking any data from database. but the same search criteria in 1st case as i described above giving result.
declare
qry varchar2(5000);
n number;
alert number;
[code]...
View 5 Replies
View Related