Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to fetch into "host structures" with Pro*fortran ?

 
REX_10
Occasional Visitor

Is it possible to fetch into "host structures" with Pro*fortran ?

I would like to have is code that would look something like:

EXEC SQL FETCH MY_CURS INTO
1 :structure.var1 ,
1 :structure.var2 ,
1 :structure.var3

(I have seen that with pro*C you could have something like:
EXEC SQL FETCH MY_CURS INTO :structure )

If it is possible to fetch directly into a record structure, what do I
declare in the "EXEC SQL BEGIN DECLARE SECTION" ?

Thanks In Advance
1 REPLY
Martin P.J. Zinser
Honored Contributor

Re: Is it possible to fetch into "host structures" with Pro*fortran ?

Hello Rex,

since this is actually more of an Oracle specific question than a VMS question you might get much better results if you look around for an answer on OTN. One link that might or might not be useful is

http://www.csee.umbc.edu/help/oracle8/server.815/a42523/ch1.htm

Greetings, Martin

P.S. It also would have been a good idea to mention that the question is about Oracle in the first place ;-)