DOA TOracleTable - SequenceField - 08/17/22 05:07 PM
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.
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.