Index: win_installer/src/insertlocale.sql =================================================================== diff -u -rce8497012193ec408066946fb6c765863dc82fdd -r8063641d2e87443222576129ec6712794375f03b --- win_installer/src/insertlocale.sql (.../insertlocale.sql) (revision ce8497012193ec408066946fb6c765863dc82fdd) +++ win_installer/src/insertlocale.sql (.../insertlocale.sql) (revision 8063641d2e87443222576129ec6712794375f03b) @@ -1,18 +1,16 @@ -DROP PROCEDURE IF EXISTS insertLocale -create procedure insertLocale - (IN _language VARCHAR(2), - IN _locale VARCHAR(2), - IN _description VARCHAR(??), - IN _rtl VARCHAR(3)) -begin - select count(*) into _numRows from lams_supported_locale - where language_iso_code = '_language' and country_iso_code = '_locale'; +DELIMITER $$ - if numRows = 0 then +DROP PROCEDURE IF EXISTS insertlocale $$ +CREATE PROCEDURE insertlocale (IN _language VARCHAR(2), IN _locale VARCHAR(2), IN _description VARCHAR(255), IN _rtl VARCHAR(3)) +BEGIN + + if (select count(*) from lams_supported_locale where language_iso_code = '_language' and country_iso_code = '_locale') = 0 then insert lams_supported_locale - (language_iso_code, country_iso_code, description, direction) - values (_language,'_locale','_description','_rtl'); + (language_iso_code, country_iso_code, description, direction) + values (_language,'_locale','_description','_rtl'); end if; -end +END $$ +DELIMITER ; +