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
Is it possible to execute a dynamic sql from forms?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
if some data is not transfered where it will get stored
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What do you understand by oracle forms?
Explain how can you use the same lov for 2 columns?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
Is it possible to have multiple layouts in a report?
What is a canvas in oracle forms?
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
Explain the different levels at which oracle form services interact.
what is tripstop report?
how do u compile a form i.e .fmb file in Unix or in dos
what is difference between group above and group left report