返回
-
标题
How do I pass values to bind variables in QSR? "Bind Variable not declared" from QSR. -
说明
How do I pass values to bind variables in QSR? Running the script in the editor provides prompts for the bind variables, but QSR just errors out with SP2-0552: Bind Variable not declared. -
原因
Running in QSR is similar to running in SQL Plus. If using bind variables, the variable needs to be defined first before before it can be recognized. -
解决办法
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 stringKeep in mind, substitution variables are just text so it may be necessary to add single quotes or the value still won't be recognized.
-
其他信息
Reference info about bind variables versus substitution variables: http://stackoverflow.com/questions/7782802/what-is-the-difference-between-bind-variables-and-the-variable-which-i-input-usi