Delphi XE 10.1 Berlin
DOA v4.4.1.0
Oracle 21c
accessing a Pluggable Database


Component: TOracelDataset
Property: SequenceField

Using the older version for Oracle 11, the SequenceField can be set for a sequence named GEN_VALUE from the drop-down list in the wizard.
The previous version worked well for running against Oracle v10 and v11.

In current version of component, the SequenceField property must now include the 'owner': DBO.GEN_VALUE which has to be edited manually in the Object Inspector.
else an exception on the sequence will be thrown.as it cannot be found ( does not exist).

This occurs even though the program user ( not the owner user ) has full permissions to do a SELECT on the sequence.

The 'wizard' that sets the field does show the sequence available, but does not show nor set the 'owner' portion of the property.