Answer Posted / lreddy
NO, IN Before Report Trigger we can use SRW.DO_SQL to
perform any DDL Operations.
For DDL Operations are internal commit.
so no need to use Commit statement in Before Reprot Trigger.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
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
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
Explain master-detail relationship with some examples.
how report can be generated if we have the database designed in oracle 10g?
a text item is there what r the different types of triggers associated with it
How can we generate report output in excel format?
Explain the various types of oracle report?
can you convert or reverse engineer a fmx back to a fmb 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 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 responsibility and how u attach How to create user and how u attach with responsibility.
hiding item in report how like that properly,thats manually but at runtime i want to do
from where do u receive the information to develop report
how do u place it in required folder