From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.3 required=5.0 tests=BAYES_00,INVALID_MSGID
	autolearn=no autolearn_force=no version=3.4.4
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 103376,99d36599289e2690,start
X-Google-Attributes: gid103376,public
From: Dmitriy Anisimkov <anisimkov@iforex.net>
Subject: Oracle Call Interface (OCI) for Ada95
Date: 2000/02/08
Message-ID: <389F60C8.A761F961@iforex.net>#1/1
X-Deja-AN: 582891258
Content-Transfer-Encoding: 7bit
X-Accept-Language: en,ru
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: Abuse Role <abuse@intercom.com>, We Care <abuse@newsread.com>
X-Trace: monger.newsread.com 949968395 209.123.73.254 (Mon,
 07 Feb 2000 19:06:35 EST)
Organization: Intercom Online (intercom.com)
MIME-Version: 1.0
NNTP-Posting-Date: Mon, 07 Feb 2000 19:06:35 EST
Newsgroups: comp.lang.ada
Date: 2000-02-08T00:00:00+00:00
List-Id: <comp.lang.ada>

Simple thick Ada95 binding of OCI.
http://cgi.tripod.com/vagul/adaoci.html
Programs do to look like :
      Connect := Logon("scott/tiger@any_tns_name");
      Prepare(Connect, Stmt, "begin :result := (sysdate -
:client_time)*60*60*24; end;");
      Bind(Stmt,Numb,":result");
      Bind(Stmt,Date,":client_time");
      Set_Value(Date,Sysdate); -- client local time
      Put_Line(To_String(Get_Value(Date),"DD Mon YY HH24:MI:SS"));
      Execute(Stmt);
      Put_Line(To_String(Get_Value(Numb),"FM999990.099"));