critical validation [message #85072] |
Sat, 29 May 2004 01:07 |
ramesh
Messages: 123 Registered: August 2000
|
Senior Member |
|
|
The question which has been asked to me in Oracle Interview :
How to write restricted build in (Like Go item ) in Validation Triggers like When – Validate – Item
Is it possible ? if not then why and if yes then why ?
|
|
|
|
|
|
Re: critical validation [message #85082 is a reply to message #85072] |
Mon, 31 May 2004 04:10 |
Anupam
Messages: 62 Registered: July 2001
|
Member |
|
|
restricted built in are built in that effect logical and physical navigation,
u cant use a restricted built where the navigation takes place.
example
lets say execute_query is a restricted bult in
and u cant use this built in pre-form trigger
becoz pre-form trigger fires just before invoking the form, so how u use execute_query here.
but u can use this built in when-new-object-instance
where u can execute restricted and unrestricted built in ,
becoz when-new-object-instance trigger fire after successfully navigation to that object
hope this work
|
|
|