span8
span4
span8
span4
This article provides an overview of some of the functionality available when working with the Oracle formats.Full details are available in the formatdocumentationchapters.
FME has improved the reporting of connection problems in the latest releases and the error messages should be self explanatory.However thisTroubleshooting Guidecan be also be used as a starting point to determine what might be causing the problem.
It is possible to run a SQL command before reading takes place,or after writing takes place,by using a parameter in the Navigator Window.
The two parameters are "SQL Statement to Execute Before Translation" and "SQL Statement to Execute After Translation".
Multiple SQL statements can be defined by using a semi-colon as a separator and using the FME_SQL_DELIMITER;directive as the first line in the set of SQL statements,asdocumented.
Working with Synonyms in Oracleis as simple as working with regular tables or views.It is just important to get the metadata entries setup correctly as is explained in the linked article.
Multiple geometry support for Oracle Spatial was implemented in FME2011.Examples of working with this kind of data is documented inHandling Data that contains Multiple Geometry columns.
When FME writes data to Oracle it occasionally has to adjust the feature geometry to properly adhere to the Oracle Spatial specification.The reason it happens is explained in more detailhere.
The tests that Oracle makes (and that FME fixes the data to adhere to) are...
In checking for geometry consistency,the function considers the geometry's tolerance value in determining if lines touch or if points are the same.
FME provides full support for working with Oracle coordinate systems.If the features being written to the Oracle database have a coordinate system tagged on them,then the Oracle SRID is automatically added to the features when they are written.More details can be found in the articleOracle Coordinate System Support.
Performing spatial queries on database tables using the FeatureReader
Let the Database Do the Work: Reading
Working with Foreign Keys: Writing Database Tables
Viewing and Inspecting PostGIS Data
Error truncating geodatabase table (Oracle errors ORA-29859 ORA-06512)
ORA-20092: Maximum number of grids per feature exceeded
Oracle clients for FME running on a 64 bit OS
© 2019 亚搏在线Safe Software Inc |Legal