How to call a trigger inside a stored procedure?Give an
example.
- 2 Answers
- 8383 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manikandan. s
triggers can't be called from procedures or functions
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / jay
Inside procedure, insert/update/delete the row in table.
The table will automatically fire the trigger. Trigger will
get fire automatically.
| Is This Answer Correct ? | 8 Yes | 2 No |
What is OCI. What are its uses?
How to loop through a cursor variable?
What is the function of Optimizer ?
How do I connect to oracle?
Why do you use stored procedures and state some of its disadvantages?
What are advantages of dateset in datastage?
What is oracle server autotrace in oracle?
where we have to use ON clause and where we have to use USING clause in JOINS
what are different types of deletes?
how may join possible between (requisition with purchase order)
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
How to filter out duplications in the returning rows using oracle?
Oracle General 
