PRO*C question??

I have a .pc (proc program) with a function that should select from the database a student's email address and put it in a variable.

This works correctly, except everytime, the first email address is blank,...I have double checked this and there is an email address for this person. Am I missing something silly?'

Code:

int getGoremalEmailAddress()
{
        printf("Campus ID<%s>\n",campus_id);
        login_oracle();
        EXEC SQL SELECT goremal_email_address
                 INTO :email_address
                 FROM goremal
                 WHERE goremal_pidm = :campus_id;
        email_address.arr[email_address.len] = '\0';
        printf("E_MAIL<%s>\n",email_address.arr);
        logout_oracle();
        return 1;
}

Outputs:
Campus ID<75799>
E_MAIL<>
Campus ID<2003142>
E_MAIL<kabdull1@test.edu>
Campus ID<2241834>
E_MAIL<iabramek@test.edu>

thanks in advance

 

It does have an email, I double checked this.

It does this for every file I run with, It prints all except the very first one.

 

I thought of that, so I actually set email_address = "NULL";
and then do a printf of email_address and it prints out the word NULL

then when I call the function, for email addressess,

it always prints the first one blank, when I know for sure there is an email address (I manually use a select statement in pl/sql)
and prints all the other addresssess???

very weird error....

thx.