Try the same thing in sqlplus. It is possible that you are connecting to different databases or schemas. So you want to make sure that you are in fact connecting to the same place. i.e. Toad stores tns entries that could be different from what is in you tnsnames.ora file.