[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

124.0. "Need examples of FORTRAN with ORACLE" by TYFYS::SHAW (Bob Shaw) Thu Apr 28 1988 18:52

    While I am not happy about it, I have been asked to look at converting
    a customer's System 1022 database application to an ORACLE database.
    The application is written in FORTRAN using the HLI of System 1022.
    
    What I need is some examples of ORACLE code embedded in FORTRAN
    in order to get an idea of the interface.  Sales brochures are all
    I have and they indicate an SQL type of interface but some examples
    would help clarify thing in my mind.
    
    Thanks in advance
    
    Mail to TYFYS::SHAW
    
    Bob--
T.RTitleUserPersonal
Name		DateLines
124.1MUNBIO::APPSIt's VAX ACMS for me!Fri Apr 29 1988 18:245
                  <<< Note 124.0 by TYFYS::SHAW "Bob Shaw" >>>
                   -< Need examples of FORTRAN with ORACLE >-

Given that ORACLE has an SQL interface, why don't you look at the
VAX SQL documentation?
124.2It's not that simple ...NSWELL::MCCARTHYLarry McCarthy, LAOMon May 02 1988 18:590
124.3... as I was saying ...SRFSUP::MCCARTHYLarry McCarthy, LAOMon May 02 1988 22:2621
  Re: .0

	Sorry, I don't have any and I never seen FORTRAN ORACLE

  Re: .1

	I have seen "C" versions. It isn't vanilla SQL - in order to 
	much of anything useful you have to use ORACLE's extensions.

	Also, in order to use ORACLE's SQL in a FORTRAN program, you 
	have to use ORACLE's FORTRAN precompiler. You also have to 
	compile the resulting FORTRAN programs /NOOPTIMIZE, or else. 

	And that's just the beginning of the unintegrated horrors of 
	using ORACLE ...

	Larry.


  PS: This is the third try at this reply ... ARRGH!
124.4FORTRAN / ORACLE examplesTPUNIV::ROARKIf my words did glow with the gold of sunshineTue May 03 1988 15:155
    There is a call interface, HLI, which doesn't need the precompiler.
    Not real fun.  I can get examples but they are not here.  How soon?
    There are sample programs distibuted with ORACLE.  Know a customer?
    
    /tim
124.5Sounds like work...TYFYS::SHAWBob ShawWed May 11 1988 17:311
    Thanks for the replies,  they just confirm my worse fears.....