I am working from home, so I use remote connection to the Oracle db hosted on Solaris. I open SHELL, LOG in to database and run a stored database procedure (which I wrote, and which runs fine from the office). The problem is that I get timed out from my shell pretty fast and that (somewhat to my SURPRISE) causes an error in the stored procedure EXECUTION.

My first question is, can my connection actually affect the stored procedure execution?

Second question is more general: Is there any command in Unix to help me kind of say "forget about the connection/shell, you don't NEED it. Just execute the stored database procedure?"

Thanks a lot!

You guys know what "database" is? I've never used Oracle... just mysql. and I've never had to remote into another linux box. So I've no clue how to troubleshoot it.... sorry.
Have you checked the obvious yet? like network connection settings and remote access settings?
What distro are you using?
What shell are you using?
Quote from: userj on October 17, 2007, 10:05:43 AM

You guys know what "database" is?