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
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame
what are the oracle forms services components include?
Explain master-detail relationship with some examples.
Is it possible to execute a dynamic sql from forms?
What is an oracle report? List its various types.
if some data is not transfered where it will get stored
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
What is the difference between bind and lexical parameter?
where do u put the report file
what is the difference between call_form, new_form and open_form?
Name the different triggers associated with oracle forms having a master-detail relationship.
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
Is it possible to have multiple layouts in a report?
a text item is there what r the different types of triggers associated with it
what is difference between group above and group left report