GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Oracle Forms 3.0
Go To First  |  Previous Question  |  Next Question 
 Oracle Forms 3.0  |  Question 12 of 66    Print  
What does an on-clear-block Trigger fire?
 
It fires just before SQL * forms the current block.



  
Total Answers and Comments: 5 Last Update: September 13, 2006   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
March 31, 2006 04:40:33   #1  
mukts        

RE: What does an on-clear-block Trigger fir...
Perform an action whenever Oracle Forms flushes the current block; that is removes all records from the block.
 
Is this answer useful? Yes | No
June 23, 2006 00:13:40   #2  
kameshakundy Member Since: April 2006   Contribution: 7    

RE: What does an on-clear-block Trigger fir...

Dear Mukts

As per my knowledge no such trigger exists at Block Level. here are the list of On-triggers
On-Check-Delete-Master
On-Check-Unique
On-Clear-Details
On-Close
On-Column-Security
On-Commit
On-Count
On-Delete
On-Error
On-Fetch
On-Insert
On-Lock
On-Logon
On-Logout
On-Message
On-Populate-Details
On-Rollback
On-Savepoint
On-Select
On-Sequence-Number
On-Update


 
Is this answer useful? Yes | No
August 30, 2006 00:08:52   #3  
priyank74 Member Since: July 2006   Contribution: 2    

RE: What does an on-clear-block Trigger fir...
Dear Kamesh You are correct that current versions do not have it. But it seems to be true for older version 3.0 probably please check the link :support.avaya.com/edoc/docs/convrnst/cnv5dsgn.pdfPlease correct me if it's not.
 
Is this answer useful? Yes | No
September 05, 2006 04:20:02   #4  
Parimala        

RE: What does an on-clear-block Trigger fir...

Hi

on-clear-block Trigger is an master detail trigger when Master-detail relation block is created and when the master block is cleared on-clear-block trigger will fire and its functionality is dependent upon the Co-ordination properties of Master-detail block.


 
Is this answer useful? Yes | No
September 13, 2006 01:59:47   #5  
prachi        

RE: What does an on-clear-block Trigger fir...
that master detail trigger name is on-clear-details. so this trigger does not exist atleast in 6 and above versions. don'y know abt lower versions
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape