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!