How to declare local variables in PL/SQL stored programs
77954Jun 22 2007 — edited Jun 22 2007Where do I declare local variables in a PL/SQL stored program?
I get compiler errors with either of the options below:
FUNCTION GET_PRINCIPAL_BALANCE (CUT_OFF_DATE IN DATE, TITLE_SN IN DATE, TOTAL_BALANCE OUT NUMBER) RETURN NUMBER IS
TOTAL_BALANCE NUMBER;
BEGIN
RETURN TOTAL_BALANCE;
END;
FUNCTION GET_PRINCIPAL_BALANCE (CUT_OFF_DATE IN DATE, TITLE_SN IN DATE, TOTAL_BALANCE OUT NUMBER) RETURN NUMBER IS
BEGIN
TOTAL_BALANCE NUMBER;
RETURN TOTAL_BALANCE;
END;