السلام عليكم ورحمه الله وبركاته
لدي PROCEDURE
CREATE PROCEDURE regestar_Beneficiaries (No Beneficiaries.NO__BENEFICIARIES%type,N Beneficiaries.Beneficiaries_Name%type,
ag Beneficiaries.Age%type,se Beneficiaries.Sex%type, L Beneficiaries.Language%type,P Beneficiaries.PhoneNumber%type,
add Beneficiaries.ADDRESS%type,acc Beneficiaries.Office_account%type )
IS BEGIN DECLARE
BEGIN
INSERT INTO BENEFICIARIES VALUES(No,N,ag,se,L,P,add,acc);
DBMS_OUTPUT.PUT_LINE('Beneficiaries added successfully');
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('SORRY,Table not found');
END;
END;اود ان استدعيها في triggers بحيث
بعد الابديت للتيبل تستدعي PROCEDURE التي في الاعلى
CREATE OR REPLACE TRIGGER regestar_Beneficiaries
BEFORE INSERT ON Beneficiaries
for each row
BEGIN
CALL regestar_Beneficiaries()
Raise_appliction_error(-20909, '.............................................' );
End ;هل استداعي صحيح
وهل TRIGGER ام يحتاج الى شرط اوشي؟