Home » Developer & Programmer » Forms » critical validation
critical validation [message #85072] Sat, 29 May 2004 01:07 Go to next message
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 #85078 is a reply to message #85072] Sun, 30 May 2004 02:31 Go to previous messageGo to next message
Tak Tang
Messages: 142
Registered: May 2004
Senior Member
I would 'work around' it by creating a timer, that does the restricted builtin when it fires.

Takmeister
Re: critical validation [message #85080 is a reply to message #85078] Sun, 30 May 2004 05:12 Go to previous messageGo to next message
ramesh
Messages: 123
Registered: August 2000
Senior Member
please give me the example

i have little bit confusion.
Re: critical validation [message #85081 is a reply to message #85080] Sun, 30 May 2004 10:11 Go to previous messageGo to next message
Tak Tang
Messages: 142
Registered: May 2004
Senior Member
I'm going to be lazy and point you to

http://www.orafaq.net/faqfrm6i.htm

Forms won't allow me to use restricted built-in's. What should I do?

Takmeister
Re: critical validation [message #85082 is a reply to message #85072] Mon, 31 May 2004 04:10 Go to previous message
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
Previous Topic: FTP-Comand
Next Topic: Form Question
Goto Forum:
  


Current Time: Wed May 01 18:05:46 CDT 2024