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


Please Help Members By Posting Answers For Below Questions

Is it possible to have multiple layouts in a report?

810


where do u put the report file

1881


if some data is not transfered where it will get stored

1684


i am writing a query select EmpNo from Emp how can i call in after parameter form

1815


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

1474


What is a canvas in oracle forms?

806


what is the difference between call_form, new_form and open_form?

965


Explain how can you use the same lov for 2 columns?

878


what are the new features introduced in oracle form services in 11g release 2?

804


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

2649


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

1904


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.

1909


What are the various configuration files that are used by oracle forms?

792


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1014


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1061