Line 113: select replace(v1.theme, '''', '') into l_theme from dual;
109: if v1.score>10 then
110: v1.score:=10;
111: end if;
112: 113: select replace(v1.theme, '''', '') into l_theme from dual; 114:
115: l_imt_string:=l_imt_string||'about ('||l_theme||')*'||v1.score||',';
116: l_count:=l_count+1;
117: EXIT when l_count=20; -- Top 20 Response theme from classification