存儲過程語法報錯 ORA-06550

execute immediate 'select count(*) from '||rec.table_name||'@todb1'|| into v_cnt;

改成 execute immediate 'select count(*) from '||rec.table_name||'@todb1' into v_cnt;