By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE
v_sql varchar2(500);
v_schema varchar(30);
v_prj_id varchar2(4000);
in_PRJ_ID SYS.ODCIVARCHAR2LIST := SYS.ODCIVARCHAR2LIST( 'B00781728','B00781628','B00781611','A43670001' );
BEGIN
FOR i IN 1 .. in_PRJ_ID.COUNT LOOP
v_sql := 'UPDATE ' || in_PRJ_ID(i) || '.SI_Recipient'
|| ' set email = email || '';'' || :addr';
BEGIN
DBMS_OUTPUT.PUT_LINE( v_sql );
EXECUTE IMMEDIATE v_sql USING 'Seshadri.K@iconplc.com';
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE( SQLERRM );
END;
END LOOP;
END;
/
1 rows affected
dbms_output:
UPDATE B00781728.SI_Recipient set email = email || ';' || :addr
ORA-00942: table or view does not exist
UPDATE B00781628.SI_Recipient set email = email || ';' || :addr
ORA-00942: table or view does not exist
UPDATE B00781611.SI_Recipient set email = email || ';' || :addr
ORA-00942: table or view does not exist
UPDATE A43670001.SI_Recipient set email = email || ';' || :addr
ORA-00942: table or view does not exist