Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uwm.edu!bionet!agate!ucbvax!CS.ARIZONA.EDU!kwalker From: kwalker@CS.ARIZONA.EDU ("Kenneth Walker") Newsgroups: comp.lang.icon Subject: Re: Icon and Oracle. A great mix Message-ID: <9010190035.AA02399@gacham.cs.arizona.edu> Date: 19 Oct 90 00:35:55 GMT Sender: daemon@ucbvax.BERKELEY.EDU Distribution: inet Organization: The Internet Lines: 22 Date: 17 Oct 90 23:35:34 GMT From: bsu-cs!bsu-ucs!earlham!johnb@iuvax.cs.indiana.edu At Earlham College (Heard of it?) we undertook a project of intergrating Icon with the Oralce Relational Database. We are finished now, and the project seems to have alot of potential. Our interface is a new built in function called 'oracle' which accepts any SQL statement (Not SQL*PLUS). The information is returned through the list data type. Neat! I was wondering if there is information that would be reasonable to "generate" rather than return in a list (I don't know much about Oracle or SQL, or data bases in general). Generating results is a more "Iconish" approach to returning multiple homogenous results than using a data structure. The programmer can then put them in a list if desired. Ken Walker / Computer Science Dept / Univ of Arizona / Tucson, AZ 85721 +1 602 621-4252 kwalker@cs.arizona.edu {uunet|allegra|noao}!arizona!kwalker