ORA-00604: error occurred at recursive SQL level 1

0
Hi all,           I am getting this following error while trying to connect to external  DB after deployment  in Sys environment .But its working fine in local environment      ORA-00604: error occurred at recursive SQL level 1      ORA-01882: timezone region not found    
asked
1 answers
1

Hi Abirami,

 

These errors are Oracle errors.

 

The reason you recieve those is

 

"The ORA-604 error (ORA-00604: error occurred at recursive SQL level 1 ORA-00918: column ambiguously defined) can occur for the internal SQL created for temporary tables if an index join access path has been chosen. This is most likely to happen in star transformation. This problem can occur on any platform.
"

There is more information on this issue for you if you ask about the errors on the Oracle community (or Google search engine)

 

Hope this will get you going,
Jan

 

answered