Untitled

PL/SQL |

980 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

  FUNCTION ADD(
        p_user SCHOOLING.iduser%TYPE,
        p_name SCHOOL.name%TYPE,
        p_address SCHOOL.address%TYPE,
        p_type SCHOOL.type%TYPE,
        p_beginDate SCHOOLING.beginDate%TYPE,
        p_endDate SCHOOLING.endDate%TYPE,
        p_graduate SCHOOLING.graduate%TYPE )
    RETURN NUMBER
  AS
    CURSOR c_school IS SELECT idSchool FROM SCHOOL WHERE name=p_name AND address=p_address AND TYPE=p_type;
    cur_school SCHOOL%ROWTYPE;
    c_idschool NUMBER;
    idschling NUMBER
  BEGIN
    OPEN school;
    LOOP
        FETCH c_school IN cur_school;
        IF cur_school%FOUND THEN
            c_idschool:=cur_school.idSchool;
        ELSE
            INSERT INTO SCHOOL(name,address,TYPE) VALUES(p_name,p_address,p_type) returning idSchool INTO idSchool;
            EXIT;
        END IF;
    INSERT
    INTO SCHOOLING
      (
        iduser,
        idSchool,
        beginDate,
        endDate,
        graduate
      )
      VALUES
      (
        p_user,
        c_idschool,
        p_beginDate,
        p_endDate,
        p_graduate
      ) returning idschooling INTO idschling;
    RETURN idschling;
END ADD;

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

Untitled

Comments