Re: Oraperl-Question

Konstantinos Agouros wrote:
>
> Does an &ora_login work across Machine-Borders? My idea is to give an Oracle-
> Connect-String instead of just the Database-Name. Does this work?
>
yes,
  actually can use the TWO_TASK variable. For V1 this will be the connect string, e.g. t:server:instance; V2 is the service name in the tnsnames.ora file. Here is snippet from a oraperl script (assumes os authentication and TWO_TASK is set correctly) :

...
# use os_authen and two task features

   $User = "/";
   $Pass = "";
   $Db = "";

# login to db

   $Lda = &ora_login($Db, $User, $Pass) || &AbEnd($ora_errstr,__LINE__);

...

phil

-- 
Philip Fielder     YellNet 505.665.3227     Fac. for Info.,Management,
EES-5/MS D452      FaxNet  505.667.1628     Analysis and Display
FIMAD/Los Alamos Nat. Lab	 	           
Los Alamos, NM 87545                   URL : http://ees.lanl.gov/fimad