[comp.ai] Prolog - Oracle interfaces

C.Eagle@massey.ac.nz (Colin Eagle) (09/21/89)

Thanks  to  those people who   replied  to  my   previous  request for
information on different versions of Prolog for various machines.

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?

Thanks in advance,
Colin

--
Colin G. Eagle
Internet: C.Eagle@massey.ac.nz
Voice: +64 63 69099 x 7523	Fax: +64 63 505611
Dept. of Computer Science, Massey University, Palmerston North, New Zealand.

johnny@edvvie.at (Johann Schweigl) (10/04/89)

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)