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




Reply With Quote