<script src="#WORKSPACE_IMAGES#jquery-1.3.1.min.js"></script>
<link rel="stylesheet" type="text/css" href="#WORKSPACE_IMAGES#jquery.ui.autocomplete.css" />
<script type="text/javascript" src="#WORKSPACE_IMAGES#jquery.ui.autocomplete.js"></script>

<script type="text/javascript">
$(document).ready( function() {
$("#P3_ACF").autocomplete('APEX', {
apexProcess: 'P_ACF',
width: 400,
multiple: false,
matchContains: false
});
});
</script>

declare
	l_search varchar2(255);
begin
    l_search := 'Агент';
    for c1 in 
(
select NAME_ROLE display_value
from APP.USER
where NAME_ROLE like '%'||l_search||'%'
order by 1 -- запрос  с l_search := 'Агент' возвращает несколько строк
)
    loop
        htp.p(c1.display_value);
    end loop;
end;

<link rel="stylesheet" type="text/css" href="#WORKSPACE_IMAGES#jquery-ui-1.8.18.custom.css" />
<script type="text/javascript" src="#WORKSPACE_IMAGES#jquery-1.7.1.min.js"></script>
<script type="text/javascript" src="#WORKSPACE_IMAGES#jquery-ui-1.8.18.custom.min.js"></script>


	<script>
	$(function() {
		var availableTags = [
			"Астана",
			"Ашхабад",
			"Красноярск",
			"Новгород",
			"Вологда"		];
		$("#P4_X").autocomplete({
			source: availableTags
		});
	});
	</script>

<script src="#WORKSPACE_IMAGES#jquery-1.3.1.min.js"></script>
<link rel="stylesheet" type="text/css" href="#WORKSPACE_IMAGES#jquery.ui.autocomplete.css" />
<script type="text/javascript" src="#WORKSPACE_IMAGES#jquery.ui.autocomplete.js"></script>