Hi i am using htmldb2.0 and trying to pull contents from appliccationprocess
The application process is
declare
begin
owa_util.mime_header('text/xml', FALSE );
htp.p('Cache-Control: no-cache');
htp.p('Pragma: no-cache');
owa_util.http_header_close;
for rec in(select file_name as "contents" from file_subjects)
loop
htp.prn(rec.contents);
end loop;
end;
my javascript is
<script type="text/javascript">
function call_ajax()
{
var get = new htmldb_Get(null,html_GetElement('pFlowId').value,'APPLICATION_PROCESS=Pull_contents',0);
var greturn = get.get();
alert(greturn);
}
</script>
I get a null when i try to alert the return..
I ran the same query (select file_name as "contents" from file_subjects)
in sqlworkshop and it gave me two records..
Any help? I am left clueless..