From: Michael Neumann <neumann@...>
Date: 2001-05-08T19:49:58+09:00
Subject: [ruby-talk:14856] Strange behaviour with Oracle connection

Hi,

I am using Oracle Module 7 from RAA together with an Oracle
8.1.6 running on Linux.

When I run the following program, which tries to connect
three times with the wrong password, it hangs after the
second try. A "[oracle <defunct>]" occurs when typing "ps".

###############
require "oracle"

p 1
begin 
  ORAconn.logon "scott", "tigr", nil
rescue OCIError => err
  p err
end

p 2
begin 
  ORAconn.logon "scott", "tigr", nil
rescue OCIError => err
  p err
end

p 3
begin 
  ORAconn.logon "scott", "tigr", nil
rescue OCIError => err
  p err
end

###############

It outputs:

  1
  #<OCIError: ORA-01001: invalid username/password; logon denierd>
  2

and hangs on the second try.
I've dived into the oracle.c file and located where it hangs. It hangs
on retrieving the error message using OCI7 function "oerhms" when a logon 
failed. When I comment the function call out, it runs.

Of course, when the password is correct, it works, too.

I guess it's the great compatibility of Oracle, isn't it?

Has anybody some hints?


Thanks in advance.

Michael


-- 
Michael Neumann
merlin.zwo InfoDesign GmbH
http://www.merlin-zwo.de