I’m trying to work with an Oracle table whose id should be generated by an Oracle sequence. This seems to be what SequenceFeature should do for me.
I create the TableGateway with
$features = new \Zend\Db\TableGateway\Feature\SequenceFeature('PV_ID', 'PV_ID_SEQ'); $tableGateway = new TableGateway('PREVIEW', $dbAdapter, $features, $resultSetPrototype);
and I get back ORA-08002: sequence PV_ID_SEQ.CURRVAL is not yet defined in this session
am I doing something wrong or does SequenceFeature not work with Oracle?
Could https://github.com/zendframework/zend-db/pull/146 be the fix for this?