Forms :: How To Change Updatable Mode
Jul 18, 2011how to change form in updatable mode?
View 1 Replies
ADVERTISEMENT
Forms :: Change Cursor Style Into Busy Mode During Process
Mar 31, 2011I have one form in which I need to change cursor style to busy while doing some process and after completing that process cursor should get to default.I have done changing cursor style but during its busy state it is allowing me to change values or click buttons.It should not allow user to change anything or click any button.
View 1 Replies View RelatedBackup & Recovery :: Change Archive Log Mode During DB Running?
Aug 24, 2011changing archive mode during DB running.Before in 9.2, 'ALTER SYSTEM ARCHIVE LOG START/STOP' is available for this job. But, after 10g/11g, it cause 'archive log stop has been deprecated'.
However, for my practice, I need to estimate archived logs size before backup them, so I need to stop archive log for a while and enable it later during DB running.
I check Oracle documents, it only mentions changing archive log mode at DB mounted but not open.
Using Dbca Silent Mode Change The Location Of Datafiles?
Oct 10, 2012usually i create oracle databases using the create database command, however im trying this time to use the dbca -silent -createDatabase -templateName General_Purpose.dbc - i have edited the General_Purpose.dbc to have the control files. datafiles etc to go to a different location other then the $ORACLE_BASE and no luck so far, whatever i do even changing the $oracle_base just dumps all into a location, how can i force it / change it - this is Oracle 11GR2 on linux
see sample of my General_Purpose.dbc
<initParam name="control_files" value="/u01/oradata/control01.ctl, /u02/oradata/control02.ctl"/>
<initParam name="diagnostic_dest" value="/backup/oracle/oradata"/>
[Code].....
Forms :: Duplicate Updatable Column On 2 Canvases
Mar 28, 2013I have a form which utilizes 2 canvases that the user can toggle between. There is a database column that I would like to have appear on both and be updatable from either place. In my search here first, I found where I could set up a non-database item and copy to it at the point of Post-Query...and that comes close, but I need both columns to not just reflect the db column but be able to update it.
I am about to try using a second trigger to move things from a non-DB column to a DB-column next, but just wondered if there is a better way. When I first compiled with the designer the duplicate column I set up as a DB column also. It only gave me warnings (that I could have lived with) but the ultimate compile my system does outside of the designer calls it an error.
Application Express :: Navigate From A Report To Different Updatable Forms Based On Condition?
Oct 11, 2013navigate from interactive report to different forms..
View 10 Replies View RelatedForms :: Run 10g In Mode Debug?
Jan 5, 2012I want to run form 10g in mode debug, however when i set break point in code and press shift+ F9 ( or run Debug by click icon on Form 10) then Form still run but not run in mode debug. Now i want to run form 10g in mode debug, how do i do?
View 2 Replies View RelatedForms :: Compressed Mode Using Text_io
Jun 14, 2011When I used to work with foxpro we had used dot matrix printer. At that time if we want, we can print in normal mode, expanded mode and compressed mode. it will be part of your spool file.
Now am printing a text file from forms using text_io package. I would like to know in this how do i print the content in compressed mode using CHR function or some other method.
Forms :: Default Mode While Entering?
May 25, 2010Is there any property that can be set at design time or dynamically altered during runtime about the default mode in which a form opens? I have created a new FORM in Forms 6i and it opens in the Enter-Query mode. I do not want to open it in the Enter-Query mode. This is because I will be doing my own execute_query on some click of a button in the form. How do I alter this Enter-Query mode in which the form opens?
View 2 Replies View RelatedForms :: Calculation Mode With Conditions
Sep 24, 2013I have 2 fields f1,f2
I define f1 a summary in calculation mode
I want to sum f1 where f2 = 5
PL/SQL :: Audit Trails For Non-updatable View?
Oct 23, 2012Database :Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
I have a requirement to develop audit trails for non-updatable view.In order to do this I created an audit trail table and row level triggers on view's underlying tables.When I update any column value from front-end oracle form then both triggers (on both tables) fire and log audit information for all columns(for both tables) into generic audit table. so far it's good but there is small difference in time interval between the triggers firing and seeing time stamp difference for both tables audit data.
sample audit data:
changed_by changed_on changed_type table_name column_name old_val new_val
myself 10/23/2012 10:15:*48* AM U TABLE1 COLUMN1 X Y
myself 10/23/2012 10:15:*48* AM U TABLE1 COLUMN2 C D
myself 10/23/2012 10:15:*49* AM U TABLE2 COLUMN5 A B
myself 10/23/2012 10:15:*49* AM U TABLE2 COLUMN6 F G
My requirement is to see all columns data from both tables in audit table with same time stamp and we will query the audit table using time stamp to show up old and new values of the non-updatable view on particular time.How can I make two triggers log the same time stamp on audit table ?.
Upgrade :: Non-updatable View After Migration
Apr 24, 2013DBA's are recently migrated oracle 10g to oracle 11g, we got some problem in views after it has been migrated to oracle 11g.
A view which is there in oracle 10g is updatable and the same view currently is not updatable in oracle 11g after migration
view is like
CREATE OR REPLACE FORCE VIEW t3_v
(A1,A2,A3)
AS
select aa.a, aa.b, bb.c
form t1_v aa, t2_v bb
[Code]...
t3_v is updatable in oracle 10g, but after migration to oracle 11g, t3_v is not updatable in oracle 11g,
we have checked underlying views t1_v and t2_v both are insertable, updatable and deletable in both oracle 10g and oracle 11g.
we checked constraints also in oracle 11g, everything is same as in oracle 10g.
Forms :: How To Cancel Enter-Query Mode
Aug 31, 2011When i entered for modification/deletion process initially i prefer to entry-query mode then execute the query.
Suppose when i am in entry-query mode but i want to cancel(abort) the mode ie. entry query. How to achieve this.
Forms :: Close A Window In Query Mode
Apr 10, 2010How do I close a window in query mode?My form has a button "Populate from Charge Master" which opens a window containing a List Item (Department Names) and 2 buttons,
1. "Select the Dept" and
2. "Cancel"
The WHEN-BUTTON-PRESSED trigger code for "Populate from Charge Master" button is as follows:
begin
SHOW_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
go_block('bl_med_dep');
enter_query;
end;
Code for "Select" button in the window is:
populate_from_charge_master(:bl_med_dep.med_dep_code,:bl_med_charge_party.charge_party_no);
execute_query;
COMMIT;
HIDE_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
GO_BLOCK('BL_MED_CHARGE_PARTY');
EXECUTE_QUERY;
Code for "Cancel" button in the window is:
BEGIN
hide_window('WINDOW_POP_FROM_CHARGE_MASTER');
show_window('WINDOW1');
GO_BLOCK('BL_CHARGE_COMPANY');
END;
Here WINDOW1 is the main window and WINDOW_POP_FROM_CHARGE_MASTER is the window which must be closed when "Cancel" button is pressed.
When I remove "enter_query" statement in "populate from charge master" trigger code, I am not able to select any of the departments from the list. and If I have that statement, I am not able to hide/close the window.
Forms :: Getting Data After Pressing TAB In INSERT MODE In 10g?
Nov 9, 2010What to write in a form for getting data after pressing TAB in 'ENTER-QUERY' MODE on a field having a LOV i.e. a trigger / program unit or what?
View 12 Replies View RelatedForms :: How To Make Query Mode Work (f11)
Apr 2, 2012I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.
View 18 Replies View RelatedForms :: A Button Has To Be Disabled In Query Mode (F11)
Apr 3, 2012Am developing a custom form. I have a block with 5 Items and one button(SUBMIT). When I go in query mode (F11), SUBMIT button to be disabled. How do i achieve this.
View 22 Replies View RelatedForms :: Disabling LOVs When Not In Enter Query Mode
Nov 5, 2010I currently have a form in which a master block populates a detail block. when the master is populated the cursor automatically goes to the detail block and sets it to enter query mode (due to the face that there are multiple details but the user may only view one at a time). To select the appropriate detail the user may select the detail from a LOV which is activated by clicking a button. once the detail has been selected and the query executed there is no real need for the LOV as the user can now edit/delete the detail. Also when adding a new detail there would be no need for the LOV as the presence of it would only confuse users. So basically the only time the LOV is usefull is during query mode to query the detail the user wants to edit/delete.
View 1 Replies View RelatedForms :: How To Use When-validate-item In Enter-query Mode
Oct 14, 2012I have to create a form and i have to use trigger when-validate-item in enter-query mode . I have read trigger when-validate-item can not use Enter Query Mode . Is there any way to do this when i enter-query?
View 5 Replies View RelatedForms :: Clear A Block For Enter Query Mode?
Jan 16, 2012I am using Forms 6i,Oracle 10g. In a form I created, I have 3 blocks, first is a toolbar type with buttons to save, exit etc., other two are one master and detail data block.
how to get the default Oracle toolbar with the buttons, save, delete etc. I dont get in my form.
When the cursor is inside the detail block and then I click on an EnterQuery button in the first block, how do I clear the detail block, using the on btn press code.
What happens when I click the Enter Query button, is that the cursor and current block becomes the button block and when I run the command ENTER_QUERY, no use.
I need to set the block in which the cursor is to be cleared for query, whether it is master or detail, by pressing the button on the first block.
Forms :: Design Mode - Horizontal And Vertical Scroll Bar
Oct 25, 2010How to create horizontal and vertical scrollbar at a time while design mode??
View 2 Replies View RelatedForms :: Query Mode Not Working At Once The Form Is Opened
Jul 10, 2012At once when I open the form when I press F11 it is not entering query mode. But if I type something in the text box placed in the form then I press F11 means it is asking "Do you want save the changes you have made?" if I press yes or no, no matter it is going for query mode. How to go to query mode without typing something in it?
View 13 Replies View RelatedPL/SQL :: Update A Base Table Using Updatable Materialized View?
Sep 12, 2013I am using sqlplus. example to update a base table using a updatable materialized view.
View 17 Replies View RelatedForms :: Enter-Query Mode - One Item In A Block Is Not Getting Cleared
May 24, 2010I have a form in which there are three blocks A,B and C. When I press F7, the form enters Enter-Query Mode and all blocks clear except block A's one item. Say, Block A has 5 items, Item1, Item2,.. Item5. When I enter Enter-Query mode, Item2 of block A is not cleared and rest all are cleared.
View 2 Replies View RelatedForms :: Sort Data In Execute Query Mode During Runtime?
Nov 15, 2012How can i sort data in the execute Query mode during runtime,i have a columns which has number, char and date field.
This below data is fetched in execute query from a table;
x1 x2 x3
1343 adfa 11/14/2012
1353 adfa 11/11/2012
1333 adfa 11/10/2012
1333 adfa 11/12/2012
1353 adfa 11/09/2012
now i like to sort like this below;
x1 x2 x3
1343 adfa 11/09/2012
1353 adfa 11/10/2012
1333 adfa 11/11/2012
1333 adfa 11/12/2012
1353 adfa 11/13/2012
how to do it?
Forms :: Can't Navigate Out Of Current Block In Enter Query Mode
May 11, 2010I 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 RelatedApplication Express :: Master-Detail Manual Tabular Updatable
Jan 8, 2013I have master and detail table , in detail table i want to build tabular form manual , i want to insert , delete and update in detail manual tabular.
tables i use :
CREATE TABLE "DISTRB_PLAN"
( "PLAN_ID" NUMBER NOT NULL ENABLE,
"PLAN_NAME" VARCHAR2(200),
"PLAN_DESC" VARCHAR2(2000),
"PLAN_NOTES" VARCHAR2(2000),
CONSTRAINT "DISTRB_PLAN_PK" PRIMARY KEY ("PLAN_ID") ENABLE
[code]....
Replication :: ORA-12013 / Updatable Materialized VIEWS Must Be Simple Enough TO DO Fast Refresh
Aug 20, 2009CREATE MATERIALIZED VIEW LOG ON ABC;
CREATE MATERIALIZED VIEW MV_ABC
REFRESH FAST
START WITH SYSDATE
NEXT SYSDATE+20/(24*60)
FOR UPDATE
AS
SELECT * FROM ABC WHERE TMSTP> SYSDATE-1;
It is working fine. Appended the Query with WHERE clause in MV_ABC MVIEWS.
DROP MATERIALIZED VIEW LOG ON ABC;
DROP MATERIALIZED VIEW MV_ABC;
CREATE MATERIALIZED VIEW LOG ON ABC;
CREATE MATERIALIZED VIEW MV_ABC
REFRESH FAST
START WITH SYSDATE
NEXT SYSDATE+20/(24*60)
FOR UPDATE
AS
SELECT * FROM ABC WHERE TMSTP> SYSDATE-1;
ORA-12013: updatable materialized VIEWS must be simple enough TO DO fast refresh
Application Express :: Updatable Report With Row Data Depended Dropdown Box Values?
Apr 17, 2013Oracle 10, Apex 4.0.
Working on this query:
SELECT waarde1,waarde2,
APEX_ITEM.POPUP_FROM_QUERY (3,waarde3,'select select ((waarde1-0.1)+(level*0.1)) d, ((waarde1-0.1)+(level*0.1)) r from (select * from lov_test where waarde1 = c001) connect by level <= (((waarde2-waarde1) *10)+waarde1)') waarde3
FROM lov_test
ORDER BY 1
The idee is to get a popup or dropdown box for "waarde3" in witch the selectable values are waarde1 to waarde2 rising with 0.1 at a time.
And this in a multi row updatable report.Example
waarde1 waarde 2 waarde3
(possible values in the dropdown box)
1 4 1-1.1-1.2 ... 3.8-3.9-4.0
3 7 3-3.1-3.2 ... 6.8-6.9-7.0
The error I get is:Error in init lov: ORA-00936: Ontbrekende uitdrukking. p_lov:select select ((waarde1-0.1)+(level*0.1)) d, ((waarde1-0.1)+(level*0.1)) r from (select * from lov_test where waarde1 = c001) connect by level <= (((waarde2-waarde1) *10)+waarde1)wwv_flow_security.g_security_group_id:1264429985836387wwv_flow_security.g_curr_flow_security_group_id:1264429985836387 Unable to initialize query. For every row in the table lov_test.
Forms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table
Dec 25, 2011when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.
View 8 Replies View Related