Xref: utzoo comp.ai:4817 comp.lang.prolog:1946
Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!gem.mps.ohio-state.edu!ginosko!uunet!mcsun!tuvie!edvvie!eliza!johnny
From: johnny@edvvie.at (Johann Schweigl)
Newsgroups: comp.ai,comp.lang.prolog
Subject: Re: Prolog - Oracle interfaces
Message-ID: <166@eliza.edvvie.at>
Date: 3 Oct 89 21:37:44 GMT
References: <135cs-suna@massey.ac.nz>
Organization: Edv GesmbH, Austria/Europa
Lines: 48

From article <135cs-suna@massey.ac.nz>, by C.Eagle@massey.ac.nz (Colin Eagle):
> I would now like information on  any Prologs which  have interfaces to
> the Oracle database:
> 	Is  there such a product?
> 	What  is its cost?
> 	What is the interface like?

InterFace Prolog has an ORACLE interface, implemented through the following
predicates:
	
	oracle_logon(UserId,Ret_code)		logon to ORACLE
	oracle_logoff(Ret_code)			logoff
	oracle_commit(Ret_code)			commit
	oracle_rollback(Ret_code)		rollback
	oracle_auto_on(Ret_code)		autocommit on
	oracle_auto_off(Ret_code)		autocommit off 
	oracle_exec(SQL_stm,Ret_code)		execute any SQL stm except 
						SELECT
	oracle_fetch_n(SELECT_query,No_of_Tuples,Tuple_list)
						execute SELECT and return
						tuples in Tuple_list


InterFace can be reached through the following adresses:

InterFace Computer GmbH
Garmischer Strasse 4
D-8000 Munich 2
West Germany
Phone: (+89)5 10 86 55
FAX:   (+89)5 10 86 28
USENET,EUNET: karin@ifcom.uucp

Oasys, Inc
230 Second Ave
Waltham, MA 02254-8990
P.O.Box: 8990
USA
Phone: (617)890-7889
Fax:   (617)890-4644

Bye, Johnny

-- 
       ------------------------------------------------------------------
       EDV Ges.m.b.H Vienna              Johann Schweigl    
       Hofmuehlgasse 3 - 5               USENET: johnny@edvvie.at
       A-1060 Vienna, Austria      Tel: (0043) (222) 59907 257 (8-19 CET)