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 a package n what r the packages availbla in report
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
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 is an implicit anchor and how is it a different form explicit anchor in a report builder?
In what situation u create the BPA.
hiding item in report how like that properly,thats manually but at runtime i want to do
why the Ctl file u put only in bin folder why not in other folder
What is the difference between flex mode and confined mode?
did u received a single file or multiple files
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
What do we mean by record group in oracle forms?
Explain the different levels at which oracle form services interact.
What is responsibility and how u attach How to create user and how u attach with responsibility.
how do u place it in required folder
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