Skip to Main Content

ORDS, SODA & JSON in the Database

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!

cannot get xls2collections to work ..

Adamc-OracleMar 1 2011 — edited Mar 3 2011
I'm running the APEX Listener standalone using the Embedded Web Container ... seems to be working fine. (using Oracle APEX Listener 1.1)

I've updated apex-config.xml to include

<entry key="apex.excel2collection">true</entry>

and restarted the listener using ..

java -Dapex.port=8081 -Dapex.images=/u01/app/oracle/product/apex_lsnr/images -Dapex.erase=true -jar apex.war

and then checked that the changes to the config file had persisted.

I've copied the APP Scott Spendolini published in http://spendolini.blogspot.com/2010_02_01_archive.html and also had a go myself ..

When I click the upload button (which has a REQUEST value of "XLS2COLLECTION"), the file gets loaded into wwv_flow_files however there isn't a collection created.

Any ideas? What's missing?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2011
Added on Mar 1 2011
1 comment
178 views