can i write commit in Before report trigger

Answers were Sorted based on User's Feedback



can i write commit in Before report trigger..

Answer / rajesh

No u can write commit before report trigger

Is This Answer Correct ?    5 Yes 0 No

can i write commit in Before report trigger..

Answer / 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

can i write commit in Before report trigger..

Answer / pushpendra saini

yes u can do commit in Before report trigger

Is This Answer Correct ?    1 Yes 2 No

can i write commit in Before report trigger..

Answer / 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

More Oracle Forms Reports Interview Questions

Can you attach an alert to a field?

2 Answers  


i don't want to give the path of .Dat file in .Ctl file dynamically i want to give how

1 Answers  


What SYNCHRONIZE procedure does ?

1 Answers  


sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How?

1 Answers   ESS,


What is a list item?

1 Answers  






How do you control the constraints in forms ?

1 Answers  


When is PRE-QUERY trigger executed ?

3 Answers  


What is a Text_io Package?

4 Answers  


What is relation between the window and canvas views?

2 Answers   ABC,


How do you trap the error in forms 3.0 ?

1 Answers  


What is the built-in used to get and set lov properties during run-time?

1 Answers  


What is a Navigable item?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)