Forms :: How To Protect Source Query In Trigger
Apr 12, 2011How to secure my source code forms like my trigger query is, how can this process possible
View 4 Replies
ADVERTISEMENT
Forms :: Query Data Source Columns
Jul 19, 2013I'm new to Oracle Forms 10g.
When I create a data block based on a table using Data Block Wizard, the block's Query Data Source Columns property is automatically populated with column definition entries corresponding to the columns of the base table.
I tried making changes to these entries, for example by changing the data types to wrong data types or even deleting them, and I found that those changes had no effect on the block at all. The form was still working as I wanted.
What is exactly the role of the block's Query Data Source Columns property.
The F1 key help says "The Query Data Source Columns property is valid only when the Query Data Source Type property is set to Table, Sub-query, or Procedure". So, explain in each context of Query Data Source Type.
Create Trigger To Execute A Stored Procedure During Source Code Compile?
Nov 9, 2009I would like to create a trigger that will execute a stored procedure when a package/function/procedure is compiled. I tried creating an update trigger on user_objects, but it statues aI cannot create that trigger tyoe on views.
View 1 Replies View RelatedForms :: Post Query Trigger With Cursor
Jan 11, 2011I create a master detail form. I created also a post quey trigger, inside I wrote the code below.A cursor looks to another table and returns to the form some values i need!
declare
cursor C1 is
select apofaa, startdate, enddate, transport
from trapofdet
where trapofdet.apofcode = :trapof.apofcode;
[code]....
How to solve the
a. frm-40737, illegal restricted procedure go block in post-query trigger
b. It seems tha returns all the records but it appears only the last one.
Forms :: Trigger To Check Field Value After Query?
Mar 8, 2010What is the trigger which should be used to check certain field value after posting the query.
Example:
I have executed the query and the records are fetched. There is one field I want to check if it is null then it should be enabled, else, keep it disabled.
SQL & PL/SQL :: Function That Returns Source Tables From A Query
Oct 16, 2013I am interested if there maybe exists any function that would return all source tables that are present in the given sql. For example function('select 'abc' from table_1, table2') would return a list containing 'table_1' and 'table_2'.
View 14 Replies View RelatedApplication Express :: Setting Source Of Popup Lov Field As SQL Query
Oct 12, 2012I am having a problem with a popup lov. When I click on the "popup icon" I can select a supplier and it is stored in the field. But when I leave the form and return later, it shows the return value instead of the display value. For example: you select "supplier A" from the popup list with ID 12. "Supplier A" is shown in the text field, when you save the form, it stores ID 12 in it. But when you return to the form, it fetches ID 12 and shows "12" in the text field instead of "Supplier A".
I tried setting the "source" of the popup lov field as an SQL query, but that didn't work for me.
Forms :: Frm-40735 Pre-query Trigger Raised Unhandled Exception Ora-06502
Jun 17, 2013When i select Filnumber(DEC99) and press QUERY button, i get error"frm-40735 pre-query trigger raised unhandled exception ora-06502".
View 1 Replies View RelatedBackup & Recovery :: Protect / Recover Data If Lost
Jan 9, 2013how to take backup and recover of oracle database and which method is best for to protect our data from lost
View 3 Replies View RelatedClusterware :: Can Use Grid Infrastructure 11.2 To Protect A Single Instance Database
Oct 12, 2012I would like to use Oracle Grid Infrastructure to protect a single-instance database.
I found these docs:
[URL]
I was unable to find a similar document for GI 11.2 . Do you know if such a document exists?
At the moment I only know that the GI is free if used for an Oracle Product, but I am not shure whether it can be used to protext external applications or single-instance databases
Forms :: Data Source For Fields?
Mar 15, 2012I have a horrible problem with EBS (actually, all problems with EBS are horrible) and I think I am stuck because of my ignorance of Forms. if I use terms that are not correct in the Forms world. The form consists of a number of named "blocks" and each block consists of a number of named "fields", not all of which are visible. I need to find the source of the data values in one of these fields. I have searched every table for a column of that name, also all the views and stored PL/SQL that I think might be relevant, but I can no find no mention of a column or variable with the same name as the field. The name does not get a hit in the online EBS tech ref manual, and only two ancient and irrelevant hits in MOS.
My question is: What are the possible sources of data for a field in a form? Have I missed any?
Forms :: Export Source Code Of Object?
Jul 1, 2010i build a form to get the source code of an object from the database and export the result into a text file but i face a problem I cannot get more than 780 line of code because i have a package with 24080 line and i have to put all this line in the text file
I attached the form
I know that the problem with the size
CM: removed unnecessary colour coding - it doesn't make it easier to read you know.
Forms :: Copy Image Or Text File From Source Directory To Destination
Oct 31, 2011how do i copy an image or a text file from ex: directory c to directory d
View 5 Replies View RelatedForms :: Call One Trigger Of Item In Trigger Of Form?
Jul 1, 2011How can "call one trigger of item in trigger of form"
View 5 Replies View RelatedApplication Express :: How To Protect Oracle Application From Code Edit On Client Side Installation
Sep 12, 2013We have developed an application for our clients,planning to deploy it in client server soon. we have plans to support the application in future,so we want to restrict the clients from any modifications. By Doubt is, 'build_status=Run only' alone,cannot protect our application from client developers to edit our application,
Because though we install our application as 'Run Only' at the time of installation in client instance,we can still import the original application and change the type to 'Build and Run Application',and run the new application as 'Build and Run'.(which is not supposed to) we want to make sure,if there is any way we can protect our application from modifications after client side installation.
Create / Update Query To Use As Trigger For Updating Info In DB Dependent Upon Time
Dec 7, 2010I am trying to create and update query to use as a trigger for updating information in a database which is dependent upon time.
I have a severity level which needs to be decreased in value after a set amount of time. the time of the action is recorded automatically on the creation of the the record. after an hour anything at severity level 2 needs to go up to 1, after 2 hours level 3 goes up to 2 and 3 hours level 4 goes up to 3
so far this is what I have
UPDATE calllog
SET timedate = current_timestamp, severityid = severityid - 1
WHERE ((severityid = 2 and timedate >= current_timestamp + (1/24)) or
(severityid = 3 and timedate >= current_timestamp + (2/24)) or
(severityid = 4 and timedate >= current_timestamp + (3/24)))
I am not getting any errors back from this sql but it is not updating the relevent information. I am using one cell for time and date in format = DD-MON-YYYY HH24:MM:SS.
Forms :: How To Change Forms Trigger Sequence
Feb 11, 2010is it possible to change the forms trigger sequence.
for example, i am writing 'when_validate_item' in item level,block level,form level.First item level will fires and then block level and at last form level. But i want to fire the trigger first at form level then block level and at last item level.
Forms :: F11(Query Mode) And Execute Query In Oracle?
Jul 17, 2011how to achieve F11(Query mode) and Execute Query in Oracle Forms?
View 1 Replies View RelatedSource For A View?
Jul 9, 2007I am new to oracle... i have one view called c1.. I want to know table of this view..
View 4 Replies View RelatedForms :: How To Create A Trigger For Age
Apr 16, 2010How do I create a trigger for the age. I want an alert to appear when the date of birth field is less than the age of 17. The formula is age=sysdate-dateofbirth
View 11 Replies View RelatedForms :: Trigger For Next Record
Jan 2, 2012I have develop the New Form.Their as a Validate require to Include in it.without saving the Current Record, it not allow to enter the New Record.
Which Trigger Used for this Validate and How to done it.
Forms :: 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 :: Trigger Getting Failure?
Oct 27, 2013I have a scenario wherein two columns compute a third one. i.e. quantity and unit_price computes "functional_amount". the column "functional amount" property disabled is set to true but there are a number of validations performed on it. Now when on a certain event "form_trigger_failure" is to be fired. the validation trigger fires multiple times (may be...).
the error alert that i have devised, is shown multiple times along with the message "validation at disabled item "functional amount" failed !". both of these messages follow one after the other unless i close the applet.
Forms :: 10g Win XP 32 Bit - Key-commit Trigger?
Oct 10, 2013I have a problem with key-commit trigger. I have written some validations and computations criteria on the block level (lines level). Actually there are a number of loops involved in it.
Problem is that the computations are performed twice. (may be the validations would also be performed twice, which couldn't be felt ). Since i read somewhere that key-commit is fired on different events, which i infered to be firing only just before database commit.
Backup Of Source Code?
Oct 15, 2009I would like to backup all source code (packages, procedures, functions, etc) every day automatically. Is there a built-in feature of Oracle to do this, I've been going through the Toad IDE and its getting to be too time consuming.
I assume I could use the export command, but not entirely sure what to specify.
I would like to backup a few tables along all code and set something in place (trigger maybe?) to send me an email when a modification is made to the production code environment.
SQL & PL/SQL :: View Source Of A Sequence
Jul 3, 2012I have a sequence named as emp_seq.
CREATE SEQUENCE EMP_SEQ
START WITH 1
MAXVALUE 99
MINVALUE 1
NOCYCLE
NOCACHE
NOORDER;
Now I want to view the source code of it after creating it. Is there any data dictionary available to see it.
SQL & PL/SQL :: Source Does Not Have A Runnable Target
Dec 18, 2012While i am trying to execute this proc,i am facing source does not have a runnable target issue.
CREATE OR REPLACE
PROCEDURE GET_CHILDS_SUB
( nid IN VARCHAR2
) AS
n varchar2;
CURSOR cur is SELECT node_id FROM test_tbl WHERE parent_id = nid;
BEGIN
[code]....
Forms :: How To Create Trigger On Backend
Oct 14, 2010I Created a form just for testing purpose [Which is i attached]
My Table is TEST0
Structure of table :
---------------------------
NOVARCHAR2(5)
NAME VARCHAR2(10)
FLG VARCHAR2(1)
My Task is When i added a record, e.g if on form, i add name - AAD But its must save on TEST0 Table like this way EMPAAD...means always concate with 'EMP'||:Block.name while saving on database..
I know how to do with front end application, but i want to achieve this task by using trigger on backend databse...how to create a Trigger on backend....i try a one trigger but it give me error- Unable to insert Record...
Forms :: Post_change Trigger On Item?
Jul 11, 2011 I am asked to change an existing field (Category_Desc) from a data block (applications) from a current form with a different field (Facility) from another table (Places) that is not used in the current data blocks. How do i do that and how should i populate the data... The common string between the table used in the form (applications) and the non used table (Places) is the ID No.
make this change and also with a possible trigger to generate the data....
Forms :: Trigger When Validate Item
Dec 18, 2012i need to pop up an alert using a trigger to test the data type of a field per example if the input is not a number an alert will popup "Please insert a number"
View 5 Replies View Related