<p style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: rgb(255, 255, 255); "><font color="#1e77d3"><br></font></p><p style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: rgb(255, 255, 255); ">
Hi!</p><p style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: rgb(255, 255, 255); ">If FDO Feature class has primary key defined and if it is of type NUMERIC than King.Oracle provider will also check for Oracle Sequence to use for primary key column. Sequence has to have a name like TableName_FDOSEQ to be used by provider.<br>
For table named RAIL sequence name of sequence is RAIL_FDOSEQ.<br>This sequence will be used by provider during inserts to populate value for identity column. If value for identity is not set during insert than provider will use next value from sequence to insert a row.</p>
Simon<div><br><div><br><div class="gmail_quote">On Thu, Dec 1, 2011 at 1:58 PM, mdelsinne <span dir="ltr"><<a href="mailto:mdelsinne@gmail.com">mdelsinne@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi,<br>
<br>
I have an improvement, although I get to build the structure in oracle with<br>
the primary key column and geometric, yet I still can not insert the values<br>
in other fields, and also I have a problem ID. I declare my property<br>
autogenerated ID but it says incorrect NULL value for the ID. I continued to<br>
look I'll let you know.<br>
<br>
Otherwise it looks in Oracle:<br>
<br>
ID (PK, NOT NULL, NUMBER(19))<br>
SDFKEY (VARCHAR2(255byte))<br>
NAME (VARCHAR2(255byte))<br>
URL (VARCHAR2(255byte))<br>
GEOM (SDO_GEOMETRY)<br>
<br>
This is normal?<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/insert-error-control-properties-with-KingOracle-tp7046704p7050418.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/insert-error-control-properties-with-KingOracle-tp7046704p7050418.html</a><br>
</font></span><div class="HOEnZb"><div class="h5">Sent from the FDO Internals mailing list archive at Nabble.com.<br>
_______________________________________________<br>
fdo-internals mailing list<br>
<a href="mailto:fdo-internals@lists.osgeo.org">fdo-internals@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-internals" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-internals</a><br>
</div></div></blockquote></div><br></div></div>