When I run a select statement that has a variable in it, when I enter the variable value in the window that prompts me for it and hit OK, I get the following message.
"ORA-00932: inconsistent datatypes: expected - got CHAR"
Replaced the colon (:), used to designate the variable, with an ampersand (&).