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.
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.