Is this in a web/CGI context? If so, have a look at mod_auth_oracle. If not, you might still draw good ideas/code from that module.