Need Help with Oracle Technical Errors

Hey everyone,

I’m reaching out to this awesome community for some guidance on an issue I’ve been facing with Oracle lately. I’m encountering a couple of technical errors that I could really use some help with.

Error 1: I keep getting an “ORA-12345: Syntax Error” when trying to execute a stored procedure. I’ve double-checked my SQL syntax, and everything looks correct to me. Any thoughts on what might be causing this?

Error 2: There’s also an “ORA-56789: Connection Timed Out” error popping up intermittently. It seems to happen when the database is under heavy load. I’m not sure if it’s a configuration issue or something else.

When I was searching about this I came across these resources/articles Connect Oracle 11 express/server from Clarion 11 application what is oracle integration cloud and as per them I have tried troubleshooting but didn’t get any solution.

If anyone has faced similar issues or has any suggestions on how to resolve these errors, I’d greatly appreciate your input!

Thanks in advance for your help :pray:

Best Regards
Faelannm

Firstly, if Oracle reports you have a syntax error, you 100% have a syntax error. Can I guess what it is without seeing the code or knowing what you don’t recognize as a syntax error? No

Secondly, ORA-12345 is “user string lack CREATE session privilege in database link”, so I don’t know where you are getting your numbers from. Similarly ORA-56789 is not an oracle error. Maybe you are raising your own errors with your own numbers?

Connection time outs are a problem on all databases. When I am working via VPN I generally get disconnected after about a half hour of inactivity. If I am in the office working over the network, I don’t get disconnected. Workaraounds in Clarion generally involve trying to convince the server that your client is busy even when it’s not.

I’m with Jon, Those error numbers don’t look legit, and they’re actually really important to help determine the problem.
So if you could post the actual error’s you received, in the case of the syntax error also some code. Without it … RTFM sorry.