Именно то, что нужно - параметризованный запрос

PROCE VIEWSOTR
LPARA RN_Department,Orders

OldAlias = select()

if type("RN_Department") !='N'
public RN_Department
RN_Department = 24506236
endif

If type("Orders") !='C'

sqlOperator ='select * from V_CLNPSPFM c;
where c.ndeptrn in(;
select rn from ins_department;
start with rn =?RN_Department;
connect by prior rn= prn;
)'
else
sqlOperator ='select * from V_CLNPSPFM c;
where c.ndeptrn in(;
select rn from ins_department;
start with rn =?RN_Department;
connect by prior rn= prn);
order by '
sqlOperator = sqlOperator+ Orders

endif
NameCursor = 'SPISOK'
hSQL = sqlconnect()
sqlexec(hSQL,sqlOperator,NameCursor)
use in 10
use dbf("SPISOK") again in 10 alias tabfam
use in SPISOK
select(OldAlias)

В смысле в 10-й области brows выведет результат как из обычной таблицы.