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

[REX_10]

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

[Martin P.J. Zinser]

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 ;-)