.declare myID 99 .declare myNote 9999999 .declare rateCount 9999 .define get_in select key, key1, rate_pr,Nt into booking_seq, f_no, print_rates, myNote from ed_tab where ed_tab.tag = 'BKNG' and ed_tab.key = 'PRN' and ed_tab.user_id = usr