From: Walter T Rejuney Newsgroups: comp.databases.oracle.tools Subject: Re: scoping in Pro C Date: Mon, 04 Dec 2000 11:36:52 -0500 Organization: xyzzy Lines: 17 Message-ID: <3A2BC824.57530DFC@Unforgetable.com> References: <90gchn$1ar$1@nnrp1.deja.com> NNTP-Posting-Host: 135.35.139.47 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.76 [en] (Win95; U) X-Accept-Language: en xmannet46@my-deja.com wrote: > Hi all, > > Been working with proc for about 6 months now and ran into a problem. > > I basically need two login's to oracle within the same executable. The > trouble is that sqlca is global and really does not allow this. Is > there anyway to overcome this? The problem isn't with sqlca. There are lots of ways that you can get around that. The real problem you are faced with is how to have separate connections. To do this you must use the DECLARE DATABASE directive and name two different database handles (the names are completely arbitrary) and then use the CONNECT directive and specify which connection you want to open.