> > > > Consider this: > > v_age, v_name, v_eno are 3 variables. > > > Exec sql Select age into :v_age from temp where name = :v_name and eno > = :v_eno; > > Suppose: > v_name ="rama" > v_eno = NULL > > > Table: temp > > Suppose the values in my table are, > Name = rama > Eno = NULL > Age = 23 > > > The prob is it does not retrieve 23 from the table. > The prob is I cannot give eno is NULL as I donât know (in practice) > whether the field will be NULL. > > Digvijoy Chatterjee