Skip to Main Content
Forums

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!

Import large websheet issue

Scott WesleyAug 3 2016

Last night I was transferring websheets between environments. Some came from a 4.2 instance, some from apex.oracle.com.

Some took an awful long time to load (5-10 minutes), relative to others. I'm just going by general observation, particularly compared to database application imports.

At first I thought maybe it was version difference because some smaller websheets still took a while to load.

However, I have a large websheet, made large due to embedded images, that I can't install.

websheet_transfer.png

I tried the normal point-click import process, which was still 'loading' when the session timed out.

This morning I tried using the Install action from the repository and the submit request timed out (on the middle tier I think).

Any tips on how to import large websheets? Or do I need to exclude the images, and perhaps try import them separately, if not re-embed?

This was importing into APEX 5.0.4 and 11g XE on a EC2 Instance accessible via ORDS3.0.6 and Apache Tomcat.

Comments

SURFThru
You could make all the columns as parameters in the update stored procedure.

Then on your table adapter add the call to the update stored proc. Name the update prc_your_update_name. Then in your code you can just run ta.prc_your_update_name(field1,field2,....). Not sure if this is what you are looking for and maybe you want to avoid typing all the colunms as paramters.

Edited by: SURFThru on Jun 22, 2011 1:45 PM
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 31 2016
Added on Aug 3 2016
#apex, #apex-discussions, #import
0 comments
116 views