Can't seem to figure it out.
Code:CREATE OR REPLACE PROCEDURE get_language_id
(
p_language_code IN CHAR(2),
p_country_code IN CHAR(2),
p_language_id OUT INTEGER
)
IS
BEGIN
SELECT
l.id
INTO
p_language_id
FROM
languages l
INNER JOIN locales nls ON l.locale_id = nls.id
WHERE
nls.language_code = p_language_code
AND nls.country_code = p_country_code;
p_language_id := COALESCE(p_language_id, 9);
END;