Interested to Buy Any Domain ? << Click Here >> for more details...
How to call a stored procedure inside a trigger? Give an
example.
- 1 Answers
- 11740 Views
- Exilant, I also Faced
- E-Mail Answers
Answer / pardeep
Using Call keyword we can call procedure inside trigger.
e.g.
CREATE OR REPLACE TRIGGER foo
BEFORE DELETE OR INSERT OR UPDATE ON <<table_name>>
FOR EACH ROW
BEGIN
CALL PROCEDURE_NAME();
END;
/
| Is This Answer Correct ? | 16 Yes | 5 No |
What is the difference between translate and replace in oracle?
What is Redo Log Buffer in Oracle?
What is an oracle database table?
How to select some rows from a table in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is the relation of a user account and a schema in oracle?
How many types of table in Oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Can a formula column referred to columns in higher group ?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
When can Hash Cluster used ?
What is oracle and what are its different editions?
Oracle General 
