RESOLUTION 1:
Define the bind variable within the script.
Sample:
variable somevar varchar2(25);
exec :somevar := 'Smith';
select * from Roster where LastName = :somevar;
RESOLUTION 2:
The alternative is to use substitution variables instead. In this case, QSR will prompt for a value, similiar to SQL Plus.
Sample:
select * from Roster where LastName = '&somevar';
-- single quotes needed here because LastName is a string
Keep in mind, substitution variables are just text so it may be necessary to add single quotes or the value still won't be recognized.
