Dear Friend,
Syntax for old and new keywords in Triggers were :Old.<Column_na me> referes the existing value of the column in a record. :New.<Column_Na me> referes the new value for the column in a record.
In your Triggers what is New_id? is a column in Temp table.
If New_id is a column in Temp table then use :New.New_id or only ID is a column in the Temp table then use :New.Id.
...
gnanda
Last Activity: Apr 29 '08, 06:57 AM
Joined: Dec 5 '07
Location:
-
-
Hi,
Use the same parameter_name v_logon in f_chk_logon inside the package body
[code=oracle]
CREATE OR REPLACE PACKAGE BODY pkg_secure_vali d
AS
FUNCTION f_chk_logon (v_logon VARCHAR2) RETURN NUMBER
IS
v_sid NUMBER;
BEGIN
v_sid := 12;
RETURN v_sid;
END f_chk_logon;
END pkg_secure_vali d
[/cod...Leave a comment:
No activity results to display
Leave a comment: