修改如下: CREATE OR REPLACE PROCEDURE INSERT_IP( pin_name IN endpoint_ip.hostname %TYPE, pin_ip IN endpoint_ip.ip %TYPE) AS vn_counter NUMBER; BEGIN SELECT count(*) INTO vn_counter FROM endpoint_ip WHERE hostname=pin_name;IF vn_counter=0 THEN INSERT INTO ENDPOINT_IP VALUES(pin_name,pin_ip); ELSE DBMS_OUTPUT.PUT_LINE('THERE HAS BEEN THE RECORD'); END IF; COMMIT; END INSERT_IP;
CREATE OR REPLACE PROCEDURE INSERT_IP(
pin_name IN endpoint_ip.hostname %TYPE,
pin_ip IN endpoint_ip.ip %TYPE)
AS
vn_counter NUMBER;
BEGIN SELECT count(*) INTO vn_counter FROM endpoint_ip WHERE hostname=pin_name;IF vn_counter=0 THEN
INSERT INTO ENDPOINT_IP VALUES(pin_name,pin_ip);
ELSE
DBMS_OUTPUT.PUT_LINE('THERE HAS BEEN THE RECORD');
END IF;
COMMIT;
END INSERT_IP;