span8
span4
span8
span4
On occasion you may need to read or write from an Oracle table that contains a custom data type.Out of the box FME will not do this without considering the custom data type.
Sample Insert Statement into a table with a custom data type looks like this in SQL:
insert into STOCKS ( stockitem,ID) VALUES(StockItem_objtyp('TEST 999',999,9.99,2),99);
Sample Select Statement from a table with a custome Data type looks like this in SQL:
select a.stockitem.s_name,a.stockitem.stockno,a.stockitem.price,a.stockitem.taxrate,id from stocks a
The attached workspace makes use of the SQLCreator and SQLExecutor Transformer's to Read and Write to a table with a custom data type.
The DDL and DML statements can be found in the attached workspace as Annotation.This will allow you to run the workspace against your own Oracle Database.
NOTE: There is no way at this time to use the Oracle Writer to write to a table containing a custom data type.
Performing native spatial queries on database tables using the SQLExecutor
Using the SQLExecutor or SQLCreator to issue commands to a database
Read Oracle Sequence Nextval and use in Counter
Using the SQLExecutor to do a SQL Join
Performing spatial queries on database tables using the FeatureReader
Executing a Stored Procedure on Microsoft SQL Server with FME
Splitting SQL statements using the FME_SQL_DELIMITER directive
© 2019 亚搏在线Safe Software Inc |Legal