I have removed the ";" from end . and I only removed t_long from my select stmt. I am comparing one instance of cl_id / symbol of penltxns table with the value of variable clid and symb. Isn't it correct. If I am executing this select stmt seperatly in sql prompt it runs then why not here... Still the same syntax error....