Stored Procedure Problems

[transio]

Can't seem to figure it out.

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;