adspace
Answer Posted / shailesh
Yes u can write directly write a coomit; in any of the
report trigger.
e.g I have created a report and written in before report
trigger
update scott.emp set ename='SMITH_1' where ename
like 'SMITH';
commit;
It worked
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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