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 have multiple layouts in a report?
where do u put the report file
if some data is not transfered where it will get stored
i am writing a query select EmpNo from Emp how can i call in after parameter form
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 a canvas in oracle forms?
what is the difference between call_form, new_form and open_form?
Explain how can you use the same lov for 2 columns?
what are the new features introduced in oracle form services in 11g release 2?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
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
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.
What are the various configuration files that are used by oracle forms?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?