Home » SQL & PL/SQL » SQL & PL/SQL » Need to know (Oracle 10g)
Need to know [message #341558] Tue, 19 August 2008 06:09 Go to next message
ksailesh
Messages: 7
Registered: August 2008
Location: India
Junior Member

I just want to know that is it possible to call procedure from trigeers?
Re: Need to know [message #341559 is a reply to message #341558] Tue, 19 August 2008 06:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is possible.

Regards
Michel
Re: Need to know [message #341574 is a reply to message #341558] Tue, 19 August 2008 06:41 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
What you 'need to know' is how to ask a proper question on a forum. Check out the guidelines they will help you.
Re: Need to know [message #341585 is a reply to message #341558] Tue, 19 August 2008 07:33 Go to previous messageGo to next message
rajeshwaranbtech
Messages: 4
Registered: August 2008
Location: Chennai
Junior Member
You can call the procedure from a Trigger
from like this

Create or replace procedure p1
as
Begin
dbms_output.put_line (' Procedure invoked sucessfully ');
End p1;

Create or replace Trigger trig1
before insert or update on t ----> (Row level Triggers)
for each row
Call p1

Create or replace Trigger trig2
before insert or update on t ----> (Statement level Triggers)
Call p1
Re: Trigger query : Need to know [message #341586 is a reply to message #341585] Tue, 19 August 2008 07:35 Go to previous messageGo to next message
ksailesh
Messages: 7
Registered: August 2008
Location: India
Junior Member

Thnaks for your repsonce
Re: Need to know [message #341592 is a reply to message #341585] Tue, 19 August 2008 08:03 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
@rajeshwaranbtech

Read and follow site rules.
Don't put solution only hint or clue as requested in OraFAQ Forum Guide, "Responding to Posts" section:
Quote:
When responding to questions, if it is obviously a student with a homework assignment or someone else just learning, especially in the homework and newbies forums, it is usual to provide hints or clues, perhaps links to relevant portions of the documentation, or a similar example, to point them in the right direction so that they will research and experiment on their own and learn, and not provide complete solutions to problems. In cases where someone has a real-life complex work problem, or at least it may seem complex to them, it may be best to provide a complete demo and explanation.


Regards
Michel
Previous Topic: Enabling my oracle Instance/ Database to allow the usage of UTL_FILE package
Next Topic: Exporting Oracle data to Excel file
Goto Forum:
  


Current Time: Mon Dec 05 08:43:31 CST 2016

Total time taken to generate the page: 0.09307 seconds