I just spoke with the DBA of our source system from where we are extracting the data and it is caused by some auditing that was enabled last week (host name too long for auditing table).
Search found 2 matches
- Mon Dec 09, 2013 9:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-00604: error occurred at recursive SQL level 1
- Replies: 2
- Views: 3251
- Mon Dec 09, 2013 1:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-00604: error occurred at recursive SQL level 1
- Replies: 2
- Views: 3251
ORA-00604: error occurred at recursive SQL level 1
We are extracting data from an oracle source using OCI connector. Its a nightly load job and has been running fine from past couple of years. The below wrror message has popped up yesterday. Method: OCISessionBegin:OCI_CRED_RDBMS, Error code: 604, Error message ORA-00604: error occurred at recursive...