I am trying to create an Oracle8_DB writer in VB.NET to write some
attirbutes to a table in Oracle. I have it working in Workbench and
the fme file lists the following as the table definition:
# --------------------------------------------------------------------
-----
ORACLE8_DB_DEF
VIZ_BOUNDS \
SQL_DROP_TABLE
yes \
XMIN varchar2
(20) \
YMIN varchar2
(20) \
XMAX varchar2
(20) \
ZMIN varchar2
(20) \
YMAX varchar2
(20) \
ZMAX varchar2(20)
Now, from what I can gather from the fmeObjects guide DEF keywords
are treated differently than any other keywords. They are not
specified when the writer is created but rather are defined in a
FeatureSchema that is then added to the writer. I have done this
before for SDE feature class outputs but I can't get this Oracle one
to work. It dies when it tries to write any features out. Here is my
interpretation of the above fme output in vb.net:
' Specify the schemas
fmeSchemaFeature.ResetFeature()
fmeSchemaFeature.SetStringAttribute
("DEF", "VIZ_BOUNDS")
fmeSchemaFeature.SetStringAttribute
("SQL_DROP_TABLE", "YES")
fmeSchemaFeature.SetSequencedAttribute
("XMIN", "varchar2(20)")
fmeSchemaFeature.SetSequencedAttribute
("YMIN", "varchar2(20)")
fmeSchemaFeature.SetSequencedAttribute
("XMAX", "varchar2(20)")
fmeSchemaFeature.SetSequencedAttribute
("ZMIN", "varchar2(20)")
fmeSchemaFeature.SetSequencedAttribute
("YMAX", "varchar2(20)")
fmeSchemaFeature.SetSequencedAttribute
("ZMAX", "varchar2(20)")
fmeWriter.AddSchema(fmeSchemaFeature)
But I must have something wrong somewhere.
Any ideas?
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
