How do I pass values to bind variables in QSR? "Bind Variable not declared" from QSR. (4234206)

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.