You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

Summary:

For a new ATP database table we are getting below error>

java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

I am able to insert into the table using SQLDeveloper.

Content (please ensure you mask any confidential information):

I have verified that there is no sequence used or defined. The column is set as Identity Column and I am not passing this column from OIC.

Version (include the version you are using, if applicable):

OIC Gen3

Code Snippet (add any code snippets that support your topic, if applicable):

DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [LoadTheFileInDB.FrdpPrereqBankDays].
Caused by java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!