johnb@yang.earlham.edu (10/18/90)
For anyone who is interested..... 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. All DMLs, DDL, and queries supported as well as a new built in &OracleError code. We chose Icon because it is such a strong language for use with strings and text. Our intergration, called OraConIt allows for sophisticated manipulation of the information returned. It could be used as a SQL front end, or as a report writer, or for DBAs be able to intergote the Data Dictionary and be able to process the data in a high-level laguage. Samples of code written in PRO*C and OraCon are very interesting to compare. (Of course OraCon takes less code.) We have developed only a VAX/VMS version, but conversion to any other platform should be painless. One needs the Oracle C run time library and the source code for that version of Icon. If you are interested by this little bit of info, (there is alot more) drop me a 'line' here. I would love to get some feedback on it. Thank you, The OraCon Group John Benjamin Johnb@yang.Earlham.Edu
kwalker@CS.ARIZONA.EDU ("Kenneth Walker") (10/19/90)
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