Forms :: Prevent Item From Being Copied?
Jan 31, 2011 how can i prevent an item from being copying. I mean to say user will not able to copy the value from the item and paste in notepad.
The item will be enabled also i can not desable it.
ADVERTISEMENT
Application Express :: Prevent Changing Value Of Item?
Sep 17, 2012Im my application, after login, I have a hidden & protected item whose value I am setting based on a logic. Also I would like to access this item's value in a application process, so session will have this value. Now I do not want anybody to be able to change the value of this item. For Eg, if my item was P1_RESP, I was able to change its value in the following way, I have an edit link on somr IR, where I redirect to another page passing some values and the URL looks like : [URL] After the browser loads, I can edit the above URL to below and click enter, [URL]
View 1 Replies View RelatedForms :: Prevent Deletion Of Record
May 6, 2010Form has insert and delete enabled.
I would like to prevent the deletion of a record based on some column value.
Something like:
IF (COLA value < 10) THEN
SHOW ALERT;
RECORD IS NOT DELETE
ELSE
DELETE RECORD AS NORMAL
END IF;
I want this to happen even before the record is marked for deletion, but I don't know where to put it. I tried a pre-delete trigger, but it does not work they way I want.
Forms :: Prevent User From Navigating To Another Webpage By Displaying Dialog Box
Dec 8, 2010how to know when a user was navigating away from the current open form (and I wanted to prevent the navigation with a dialog box) because they had entered a new URL in the address bar and were trying to navigate to it? I've seen a reference to it from an ADF perspective -> [URL]
but was wondering how to do it within Forms?
The reason for this is that i would want to prompt the user to confirm that they wanted to exit the form as potentially they would have a record (in the form) flagged as being updated and as such no other user (including themselves) could susbequently access it. So, I'm basically wanting to know if there is a way to catch the fact that the user is about to navigate to another web page.
Is it by using javascript and if so, how would it be implemented?
Forms :: Prevent Duplicate Record Entry Date Wise?
Oct 10, 2011we have a table attendance_d with no constraint which have duplicate emp_id we want to stop duplicate emp_id on the same date. if employee's record already entered in today's date then duplicate Error message must show if he tries again to enter the same record. for this i have written the following code but it is not working date wise some body. i want to use on WHEN VALIDATE ITEM TRIGGER in oracle forms 6i.
DECLARE
l_count NUMBER;
BEGIN
[Code]....
i have tried my best to format the syntax of code but in preview it showing like as above i have formated in toad by using the key ctrl+shift+f.
Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item
May 22, 2010I have 2 items in my form:
1) Text Item
2) Tlist
Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .
Forms :: Move Cursor To Another Item From WHEN-VALIDATE-ITEM
Apr 19, 2012I need to move to control to another item in a same block from WHEN-VALIDATE-ITEM trigger. [WITH OUT USING ANOTHER TRIGGER]
View 6 Replies View RelatedForms :: Update Database Item When Non-database Item Is Manually Updated?
Mar 10, 2011I am having trouble changing a non-displayed field when a displayed field is changed.
When a user wants to un-assign a territory they want to just null the ID field (non-database item). I then need to null the PIDM field(not visible, database item) for that one record.
I tried this, but I end up putting null on all the records instead of just the one record, which ends up un-assigning all the territories not just the one.
Is there a way to assign the null to the PIDM field associated to the ID field of that particular record.
PL/SQL :: What Are Constraints Copied
Aug 23, 2013When a table structure is copied from another table.What are the constraints copied and why?Unique keyPrimary keyForeign KeyCheckNot null.
View 10 Replies View RelatedPerformance Tuning :: Does Partitioning Need Constraints To Be Copied
May 4, 2013I am doing partitioning in the table ap_invoices_all and i have gone through all the process of i am making a script for a table and process
1. Create the new partitioned table with the same column structure as the original and with the partitions.
2. Insert data from the original table to the partitioned. Use parallel DML.
3. Rename the indexes of the original table
4. Create indexes to the partition table with the same columns as the original indexes.
5. Save the source code of the original table triggers
6. Rename the triggers of the original table to OLD
7. Do the table renaming. Rename original table to OLD and the partitioned table to original.
8. Drop the synonyms for the OLD table and recreate to point to the new partitioned
9. Grant the appropriate privileges to new partitioned table.
10. Create the triggers to the partitioned table
i want to know do i need to copy the constraints of the original table to the partitioned table?
Data Guard :: Archive Copied Onto DR But Not Applied?
Jul 2, 2011We have Oracle 10G dataguard configured,
DGMGRL -
Show configuration;
Shows status "SUCCESS"
Also
Archive log list
shows the proper archives in PROD as well as DR
But, when we check the Archive Applied ="YES" its shows result as "BLANK"
Backup & Recovery :: Restore Database / Copied Archivelogs
Dec 14, 2011Question: does oracle recover past the scn mentioned in the control file or do you need recover using backup control file for it? No specific scn,time specified.
Scenario: Restore database on new server + copy archivelogs from original to minimize data loss.
Backup : 5 AM
Archivelogs: 7 AM
New server:
Configure dummy instance
Restore spfile from tape
Restore controlfile from tape: SCN 5AM
Restore database (no scn specified) from tape: : SCN 5AM
Copy archivelogs from old server to archivelog new location: SCN 7AM.
Recover database
open database -> SCN 5AM or 7AM?
Does it recover till SCN 5AM (controlfile) or SCN 7AM (latest scn in copied archivelog)
Backup & Recovery :: Restore Using Copied Oracle Folder
Jan 24, 2012Opening the database with manually copied oracle data folders and files. Due to my server crashed we were forced to format the system. In that my friend by mistake copied the oracle folder (All data files, redo log files) manually instead of taking a backup in a procedural manner. Now we need to restore all the data. Would it be possible to restore the data with copied data file. If so how?
View 10 Replies View RelatedPL/SQL :: User Copied Table Data From Prod To Other Schema?
Apr 22, 2013has copied one table data from Production to any other schema , know which user has done this ?
View 1 Replies View RelatedPL/SQL :: Update Records In Such A Way That Each Student's Marks Are Copied In New Column
Oct 22, 2012i have a requirement, wherein i have to update records in such a way that each student's marks are copied in a new column of the next student record.
View 10 Replies View RelatedApplication Express :: Report Columns Duplicated When Region Is Copied
May 15, 2013Re: Report Columns duplicated when region is copied.
When I copy a region which I have created via master-detail form, the report columns are duplicated. I'm actually copying the whole page but I have had other cases where I just copying the desired region and the columns were duplicated there as well. And, of course, there is no way that I know to delete columns from the form. But I doubt because -- in at least some cases I've tried -- the columns seems to be "linked" in that a change to one copy of the column was duplicated in the other when changes were applied.
In the example (below), there are three regions on the page and the problem occurs in region 2. (I think I will likely delete the first region.) It's been agonizing trying to get the report of region 2 and the tabular formish edits of region 3 on the same page. I made this in Oracle 11.2 in our APEX 4.1 and imported it to 4.2. You can see it here:
WS apex_examples_01
demo
demo
Appl. 991204
Page 57 is the original page created in 4.1 and imported
Page 58 is the page copied from 57 under 4.1 and imported
Page 59 is the page copied from 57 under 4.2 (Same result as in 4.1.)
If you want to try the page, select DSD01 from the DSD LOV, click "Query Process" and then click the edit icon. Ignore the region 1 errors -- I'll probably delete this region. The data is region 3 is for Run Date 12-May-13.
Is there some setting that allows this region to be copied without duplicating columns?
P.S. I think I know why it happens: APEX hates me!
Forms :: Barcode Label Printing - Prevent Label From Printing N/V For Null Values?
Jul 8, 2013I have set up a label which interacts with our LIMS system. I have set up variables on this label which pull in attribute values from the available tokens. When the attribute value is null, the label is automatically inserting 'N/V' onto the label.
I would prefer for the variable to appear as a blank field on the label when the attribute value is null in the LIMS. can't find anything in the user's manual. Perhaps there is some setting where you can define what to display for null values. I can't seem to find any information on this.
Client Tools :: Leading Zeroes Are Getting Wiped Off When Results Are Copied Into Excel
Apr 13, 2012We wrote a query to spool the results in TAB delimited flat file, Results are ok but when copied into excel the leading zeroes are getting wiped off.
Example:
Result: 0000123 and when copied into excel the value is just 123. I need to retain the value as it is 0000123.
Can we control it in the query itself rather than correcting the excel.
PL/SQL :: Prevent Overlapping Date
Nov 16, 2013I use Oracle 11.2.0.3.I have APPOINTMENT table:(ID NUMBER PK , FROM_TIME TIMESTAMP , TILL_TIME TIMESTAMP , NOTE VARCHAR2 (200))I want to prevent end users from making an appointment that overlaps with other appointments. I created this trigger:
Create or replace TRIGGER "APPOINTMENT_CK"
BEFORE
INSERT OR UPDATE ON APPOINTMENT FOR EACH ROW
BEGIN
IF
[code]....
But, it looks like I cannot use column name here.
Forms :: Text Item In Oracle Forms
Aug 22, 2010How to get the value of text item in Oracle forms to pass as a parameter in stored procedure.
View 4 Replies View RelatedSQL & PL/SQL :: Prevent Duplicate Column Value Using Trigger
Mar 8, 2010I want to avoid duplication on old_nic_no and new_nic_no number in a Table, for this i am using a following trigger
create or replace TRIGGER chk_ip_duplications
BEFORE UPDATE
ON cb_insured_person_bak
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
[Code]...
when i use following command
update cb_insured_person_bak set new_nic_no = '34601-0774284-9' where eobi_no = '4300G043746'
34601-0774284-9 already exist with another eobi_no , i expect error described in rise_application_error clause but i give following error
ORA-04091: Table cb_insured_person_bak is mutating..........
How i can resolve this problem.....
SQL & PL/SQL :: To Create A Trigger To Prevent Transactions
May 10, 2013Im trying to create a trigger to prevent transactions like insert, update and delete based on two conditions:
1) Friday
2) Between 5pm to 8am
Prevent Other Sessions From Writing To The Tables In Procedure?
Jun 26, 2013here' my code.
delimiter //
SELECT CONNECTION_ID()//
LOCK TABLES source.jos_daikin_control_card_fcu_model WRITE//
[Code].....
ERROR 1192 (HY000): Can't execute the given command because you have active lock
ed tables or an active transaction
Is there a way to prevent other session from accessing the tables called in the procedure?
Security :: Prevent Users From Updating Tables
Sep 9, 2010i've created a schema, which contains 30 tables. the tables are accessed & updated through a web based application. i've made public synonym for all tables for some reasons. how can prevent any one other than application users from updating the tables from Sqlplus.
View 2 Replies View RelatedCan Trigger Prevent Insert And Update To Table
Mar 4, 2013We would like to create functions to insert and update our tables and would like to make it not possible to update and insert the table directly outside of the function. Is there a way to do that in the trigger?
View 1 Replies View RelatedForms :: Set Validate Item From LOV To Yes
May 29, 2011i have a table called equipment containing engine_type_id.in the equipment form that is based on the equipment table, i added a non database item called engine_type.
i added an LOV for the engine type field, so that the user can choose the engine type from the the egine types table. i made the engine type id hidden. and set the validate item from LOV to yes.on post query trigger, i selected the engine type into the nondatabase field.
the form is working properly.
when i push CTRL F11 (query) and scroll, even if i didnt change anything the form builder asks me , do u want to save changes.
Forms :: How To Get Menu Item Name
May 5, 2009I have created a Menu in forms 6i,
I want to get Menu Item Name When i pressed any menu item in runtime..
e.g, i have a menu items like,
MENU1
ITEM1
ITEM2
ITEM3
when i pressed ITEM1 then it should display ' MENU1.ITEM1 ',
how can i get this..?
REMEMBER !! I WANT TO GET MENU ITEM NAME IN RUNTIME , WHICH IS CREATED IN DESIGN TIME.
Forms :: Create More Than One LOV To Item?
Feb 19, 2011how can i give more than one lov item to an item?
View 3 Replies View RelatedForms :: Next-Item Trigger
Aug 16, 2013I have a multi row form (Order Entry form in E Business Suite). When I enter data in a row and error down the validate-item trigger fires and runs some code to check for duplicates, etc and after the cursor should go down to the next row. It goes back to the original row.
View 4 Replies View RelatedForms :: Go-item Not Working?
Feb 1, 2012I 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');