在第14行创建函数时出错 [英] Error in creating function at line 14

问题描述

CREATE OR REPLACE FUNCTION getsal(id_param NUMBER)
RETURN NUMBER
IS
    sal_increase employees.salary%TYPE;
    tenure NUMBER;
    sal NUMBER;
BEGIN
    SELECT
        salary,
        MONTHS_BETWEEN(SYSDATE, hire_date)/12
    INTO
         sal_increase,
         tenure
    FROM employees
    WHERE employee_id = id_param;
    IF tenure <= 12 THEN
        sal_increase := 0;
    ELSIF tenure BETWEEN 13 AND 36 THEN
        sal_increase := sal_increase+(sal_increase * .05);
    ELSIF tenure BETWEEN 37 AND 60 THEN
        sal_increase := sal_increase+(sal_increase * .1);
    ELSIF tenure BETWEEN 61 AND 120 THEN
        sal_increase := sal_increase+(sal_increase * .15);
    ELSE
        sal_increase := sal_increase+(sal_increase * .2);
    END IF;
        RETURN sal_increase;
END;

DECLARE
    newsalary NUMBER;
BEGIN
    newsalary := getsal(101);
    DBMS_OUTPUT.PUT_LINE('New Salary:'|| newsalary);
END;

推荐答案

SELECT INTO语句不是正确的.但您可能会遇到更多语法错误.

问候

SELECT INTO statement is not correst. but u might get more syntax errors.

Regards

这篇关于在第14行创建函数时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！