Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ajax calling application process

479262Jan 9 2006 — edited Nov 12 2007

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..

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2007
Added on Jan 9 2006
16 comments
1,775 views