Xref: alice comp.databases.oracle.tools:35278
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-peer.gip.net!news.gsl.net!gip.net!den-news-01.qwest.net!qwest!nntphub.cb.lucent.com!news
From: Kenneth C Stahl <BlueSax@Unforgettable.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Pro*c Connection to db
Date: Tue, 09 Nov 1999 10:12:33 -0500
Organization: xyzzy
Lines: 21
Message-ID: <382839E1.D4A84ED5@Unforgettable.com>
References: <807spt$90e$1@perki.connect.com.au>
Reply-To: BlueSax@Unforgettable.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.6 [en]C-CCK-MCD EMS-1.4  (Win95; U)
X-Accept-Language: en-US,en

Tom Zamani wrote:
> 
> Hi there,
> We have a Pro*C program to archive data, each time this module is called it
> will login to database and does the archiving, is there any way which I
> could make it to login once, so I can avoid login to the database all the
> time.
> I could put the all logic in the Pro*C program and let it run all the time.
> 
> The other method  is to make the precompile the pro*c get the c code and
> make it as external procedure call.
> in either way it will have to relogin to the database.
> 
> Is there any way to avoid this?
> Tom

Could you make another stab at explaining this? "The other method  is to
make the precompile the pro*c get the c code and make it as external
procedure call." doesn't make much sense.

Try to explain what you are attempting to "archive".