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!

How to flush / push htp buffer to browser

Martin Giffy D'SouzaAug 17 2011 — edited Aug 17 2011
+I posted this question on the SQL / PL/SQL forum (2271530) Since this is a web centric forum I thought I'd post here as well.+

Is there a way to flush or push the htp buffer to the browser?

For example, suppose you had a procedure.
...
htp.htmlopen;
htp.p('hello');
htp.helpclose;
...
-- No more HTML to print

-- Still some more code to run
At the top of the procedure you print some HTML code. You want it sent right away to the user but you still have some other PL/SQL code to run. Right now it appears as though the entire procedure needs to finish before the HTML is sent to the browser.

The reason I'm doing this is to test a new HTML 5 technique which allows for servers to push data to client. The thing is that I need to be able to force / push the contents of the buffer to the browser while keeping the procedure running.

Thank you,

Martin
-----
http://www.ClariFit.com
http://www.TalkApex.com
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2011
Added on Aug 17 2011
4 comments
1,166 views