Answer Posted / pranabesh

Procedures can be called directly by name with parameters
[if any] in the trigger

ex:
suppose i have a procedure pro1(var1 in number, var2 in
number) which i want to call from trigger trig1

CREATE OR REPLACE TRIGGER TRIG1
AFTER UPDATE OF SAL ON EMP
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE

L_VAR1 NUMBER;
...
...
BEGIN
...
...
-- CALLING THE PROCEDURE

pro1(10,20);
END

Why having clause is used in sql?

982

---

What is cursor and why it is required?

1183

---

What is the meaning of disabling a trigger?

1182

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2084

---

What is ttitle and btitle?

1065

---

How can we avoid duplicating records in a query?

984

---

how to get a list of columns in an existing table? : Sql dba

966

---

How do you sort in sql?

1030

---

What are the types of functions in sql?

1021

---

What does an inner join do?

1188

---

Enlist some predefined exceptions?

1063

---

What is sqlexception in java?

999

---

what is the different between now() and current_date()? : Sql dba

1026

---

What is procedure and function in sql?

1003

---

What is a composite primary key?

1095

---