We have a trigger on data base.in the trigger body we have created a body using dbms_output.put_line(********) ;this should be firedwhen ever trigger executed;

  • Interview Candidate
  • 8
  • 4211

Showing Answers 1 - 8 of 8 Answers

CHIT SENTHILKUMAR

  • Mar 15th, 2006
 

TRUE ... displays the messge from dbms_output.put_line

Nantha

  • Apr 18th, 2006
 

Where will it print the output? It won't print that.

  Was this answer useful?  Yes

Bhupendra Singh Verma

  • Apr 18th, 2006
 

This will print the message only if the DML is run at SQL prompt and offcourse serveroutput on has been issued.

rajanipriya

  • Jun 6th, 2006
 

According to bhupendra,.. "If only the DML is executed at the SQL prompt",..

  My question is where else can we execute it other that SQL prompt???keeping aside form triggers,.. database triggers rise only on a DML operation that can be executed at the SQL  prompt.

  Please suggest me if i am wrong.

  Was this answer useful?  Yes

binurajnair

  • Aug 3rd, 2008
 

Database triggers fires whenever a database operation happens. It can happen through any application software developed using form builder, reports builder, Java or various other programming tools. In those cases dbms_output.put_line will not display any message.

  Was this answer useful?  Yes

Radha

  • Jul 14th, 2011
 

Triggers fire when any condition on such trigger is satisfied...but we don't know when that trigger is going to be fired and if it is fired where can we see output of DBMS_output.put_line.
If we want to see output of trigger when it is fired we should mention Raise_application_error in trigger.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions