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!

Can't see some data in excel after using the export_excel package

627274Oct 9 2008 — edited Oct 24 2008
After using the the export_excel package some cells in the spreadsheet display '###########'. If the cell is selected the data will show but it disappears when you leave the cell and try to print it. Does anyone know what is causing this problem?

Thanks
This post has been answered by ATD on Oct 24 2008
Jump to Answer

Comments

John O'Toole
Hi,

The sdo_gtype of your sample geometry is 3002 which suggests you are storing x, y, z values. i.e. heights in the z.
Based on your explanation of the data, it sounds like you should be using Linear Referencing - read about it here (
http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_lrs_concepts.htm#BABIIFFH).
Note that use of Linear Referencing requires an Oracle Spatial license - Locator is not enough.

SDO_LRS has a variety of functions/operators which will help you achieve your goal.
E.g. SDO_LRS.LOCATE_PT
http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_lrs_ref.htm#i85478

John
1 person found this helpful
1013173
Hi,

Thanks for the tip.
I used the LOCATE_PT function with the SDO_UTIL.GETVERTICES function and it works.

My query is (for hisghway id = '1000' and km = 5000):

select li.*, t.*
from HIGHWAYS li , table( sdo_util.getvertices( SDO_LRS.LOCATE_PT( li.geom, 5000 ) )) t
where li.id = '1000'
;
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 21 2008
Added on Oct 9 2008
#apex, #apex-discussions, #excel, #pl-sql, #plsql
14 comments
572 views