Can u explain me the Restricted and unrestricted procedure
in Forms And reports and example as well ??
Answer Posted / prabhudatta barick
Restricted procedure that affects the basic functions of
SQL * Forms and Report
. It cannot used in all triggers except key triggers.
Unrestricted procedure that does not interfere with the
basic functions of SQL * Forms and Reports it can be used
in any triggers.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is an SQL FORMS ?
What is an oracle report? List its various types.
Name the different triggers associated with oracle forms having a master-detail relationship.
In what sequence do triggers get fired by oracle forms?
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
from where do u receive the information to develop report
Is it possible to have multiple layouts in a report?
What is an oracle report?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
what are the new features introduced in oracle form services in 11g release 2?
What is responsibility and how u attach How to create user and how u attach with responsibility.
i am writing a query select EmpNo from Emp how can i call in after parameter form
Is it possible to execute a dynamic sql from forms?
What is the difference between bind and lexical parameter?
What do you understand by lov?