Answer Posted / rupesh babu k
This is used to run DDL or DML commands in forms.
In reports srw.do_sql
In pl/sql execute immediate and dbms_sql
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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
What do you understand by lov and how can it be used?
what is tripstop report?
List the different types of columns in oracle reports.
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
In what sequence do triggers get fired by oracle forms?
What is the difference between flex mode and confined mode?
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
Explain the different levels at which oracle form services interact.
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
How can we expand Parameter Form Canvas on Reports 6i?
what exactly u write in when_new_form_instance
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
if some data is not transfered where it will get stored
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