in reply to Test Oracle connection

I agree with holli, you would find it easier to use Perl.
However, you say that sqlplus 'hangs', and it would be good to find out the reason. When you run sqlplus from the command line under these conditions, what happens? Do you have truss(1) or strace(1) available to see why it has stopped?

Replies are listed 'Best First'.
Re^2: Test Oracle connection
by jcc (Sexton) on Apr 25, 2006 at 17:23 UTC
    sqlplus is an interactive command shell. It won't exit until something explicitly tells it to. Nothing in this example gives it that command.