Create Or Replace Procedure BM_ADD (p_id varchar, p_name varchar) IS - v_count number; begin
/ * - Check if the input parameter is empty if p_id is null or p_name is null kil1np_out: = 'Enter the value of the input! End IF;
- This username already exists Select Count (*) INTO V_COUNT from BM a where Upper (ID) = Upper (p_id); if v_count> 0 ThenP_out: = 'This user name already exists'; return; end if; * / INSERT INTO BM (ID, Name) Values (p_id, p_name); - Commit; - p_out: = null; - Return;
/ * - Exceptionwhen Others kil_out: = 'during insertion, exceptions during the insertion!'; Return; * / End;
