Newbie question about REFCURSOR Bind Variables

Can anyone help me ? ,

The doco show the below code to manipulate result sets in SQLPLUS which is fine interactively

SQL> VARIABLE dept_sel REFCURSOR
SQL> BEGIN
  2 OPEN :dept_sel FOR SELECT * FROM DEPT;   3 END;
  4 /

..but what about in a command file. When I try it I get the error         

        Bind variable "MYVAR" not declared.

I would appreciate some help. Received on Fri Sep 18 1998 - 00:00:00 CEST