Additional Notes:
When I perform the steps I describe above I am able to move points, modify attributes and save edits so they are commited to the Oracle database while using non-versioned editing.
I am not able to add new records. I've forced attributes to be entered before new shapes created are commited.
I've put code below to show steps.
--Create Tables--
CREATE TABLE TBL_TESTING
(
NODE_ID NUMBER(10,0) NOT NULL,
NODE_NAME VARCHAR2(50),
SE_ANNO_CAD_DATA BLOB,
SHAPE MDSYS.SDO_GEOMETRY NOT NULL,
CONSTRAINT PK_TEST_NODE_ID PRIMARY KEY (NODE_ID)
);
--Insert Records--
INSERT INTO TBL_TESTING (NODE_ID,NODE_NAME,SE_ANNO_CAD_DATA,SHAPE)
SELECT NODE_ID, NODE_NAME, SE_ANNO_CAD_DATA, SHAPE
FROM FRE2.TST_TELCO_NODES T
WHERE T.NODE_ID < 10;
--Create Views--
CREATE OR REPLACE VIEW PTS_TEST AS
SELECT NODE_ID, NODE_NAME, SE_ANNO_CAD_DATA, SHAPE
FROM TBL_TESTING;
--Update SHAPE Column SRID's--
UPDATE TBL_TESTING T
SET T.SHAPE.SDO_SRID = 2804;
--Insert SDO Geometry Metadata--
INSERT INTO USER_SDO_GEOM_METADATA VALUES
('TBL_TESTING','SHAPE',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X_COORD',-200000,570000,0.0003),MDSYS.SDO_DIM_ELEMENT('Y_COORD',-125000,250000,0.0003)),2804);
INSERT INTO USER_SDO_GEOM_METADATA VALUES
('PTS_TEST','SHAPE',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X_COORD',-200000,570000,0.0003),MDSYS.SDO_DIM_ELEMENT('Y_COORD',-125000,250000,0.0003)),2804);
--Create Spatial Indices--
CREATE INDEX IDX_TEST ON TBL_TESTING(SHAPE) INDEXTYPE IS MDSYS.SPATIAL_INDEX;
--Create Sequence--
CREATE SEQUENCE SEQ_TEST
MINVALUE 1
MAXVALUE 1000000000
START WITH 1000
INCREMENT BY 1;
--Create Sequence Trigger--
CREATE OR REPLACE TRIGGER TRG_SEQ_PK_TBL_TEST BEFORE
INSERT ON TBL_TESTING FOR EACH ROW BEGIN
SELECT seq_test.NEXTVAL INTO :new.NODE_ID FROM DUAL;
END;
/
--sdelayer -o delete -l TBL_TESTING,SHAPE -u ARC1 -p ARC -D DCNSDB -N--
--sdelayer -o delete -l PTS_TEST,SHAPE -u ARC1 -p ARC -D DCNSDB -N--
--sdelayer -o register -l TBL_TESTING,SHAPE -C NODE_ID,USER -t SDO_GEOMETRY -e p -E -200000,-125000,570000,250000 -P BASIC -u ARC1 -p ARC -D DCNSDB--
--sdelayer -o register -l PTS_TEST,SHAPE -C NODE_ID,USER -t SDO_GEOMETRY -e p -E -200000,-125000,570000,250000 -P BASIC -u ARC1 -p ARC -D DCNSDB--