Hello,

I have this sql string in my procedure:

Code:
SQL4:='INSERT INTO TMP.ALIN_SITEDEF(SITEDEFID, PARENT_SITEDEFID, SITEID, SITEDEFNAME, SITEDEFLEVEL, SITEDEFSQL, SITEDEFTYPE, BUSINESS_UNIT,BRAND)
VALUES('||_min_sitedefid||','||_parent_sitedefid||','||_siteid||','||quote_literal(_business_unit)||' '||quote_literal(_level_1)||',2,''BRAND_COMPOSITE = '''||quote_literal(_business_unit)||''' AND LEVEL1 ='''||quote_literal(_level_1)||''''',''CONTENT_MAP'','||quote_literal(_business_unit)||','||quote_literal(_level_1)||')';
when I execute the procedure, I recieve this error:

Code:
ERROR [42000] ERROR:  found "'" (at char 170) expecting next item or end of list
 'INSERT INTO TMP.ALIN_SITEDEF(SITEDEFID, PARENT_SITEDEFID, SITEID, SITEDEFNAME, SITEDEFLEVEL, SITEDEFSQL, SITEDEFTYPE, BUSINESS_UNIT,BRAND)
VALUES(401,-1,7,'Cloud' 'Cloud',2,'BRAND_COMPOSITE = ''Cloud'' AND LEVEL1 =''Cloud''','CONTENT_MAP','Cloud','Cloud')'
What am I doing wrong ?