The error I'm getting is:
ORA-00900: invalid SQL statement
I went a step further than the char thing (which wasn't causing the error anyway) and did this.... still not working:
Code:
CREATE OR REPLACE PROCEDURE get_language_id (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 = 'en'
		AND nls.country_code = 'US';
END;
Incidentally, I'm attempting this through a JDBC connection, so my complete error is:
java.sql.SQLException: ORA-00900: invalid SQL statement
I have created other stored procedures through the same connection without problems. This one just seems to want to be a pain.