mldenny@bsu-cs.UUCP (Michael L. Denny) (10/22/87)
Hello, This is my first post so please bear with me! I'm currently working on a FORTRAN program that is using embedded ORACLE SQL. This program contains about 20 Subroutines where the call to each just uses 4 parameters. [ex. CALL NR_CONC(patient_ssn,patient_name,student_init,student_ssn) same parameters for each subroutine. ] There is no problem with the call. The problem occurs when I display the selected data from the Data Base. A BETTER EXPLANATION: When I display the data retrieved from the Data Base it is fine... the main problem occurs when I select a different patient from the Data Base. When I try to display this new patient some of the fields are still the same from the previously displayed patient! The questions is this: 1.) Why do these variables still retain some of the old information after the SELECT INTO statement? Or the same after I declare FILE# CURSOR FOR SELECT and read from the Data Base? (What I have noticed is that the fields are either null or just contain a CR, this is due to the insertion of the data into the data base. So, that when the selection is done it just ignores these fields and doesn't do any padding.) What I have done so far, to get around the inconvience of this, is to blank out the field so that at least a blank is there so no repitition of data is displayed. What I would really like to do is find a way to blank out the fields without having to put a blank in each variable.(Putting a blank into each variable added at least 2K to each Module.) I have tried to use the COMMON block statement but that didn't seem to work or I might not have set it up right. The way I was thinking about blanking out these fields is when I PCC (pre-compile) or in the definition of the table itself. Any contributions or suggestions will be greatly appreciated. The system I'm working on is a VAX 11/785 running VAX/VMS v4.5 and using ORACLE v4.2.2 - Interim Release. Thanks again, Michael L. Denny /Student Intern Ball State University Computing Services Ball State University Muncie, In. 47304 [This is a project for BSU UCS but I'm working on my own; so this message does not necessarily reflect the views or ideas of BSU UCS.] *** *** UUCP: <backbones>!{iuvax,pur-ee,uunet}!bsu-cs!mldenny *** *** p.s. If this is not clear a definition, send me a reply with some specific questions on why you weren't able to understand my question. I will then repost with a better and clearer definition of my problem. thanks again!