srw.do_sql() 1

[mbl73]

How do you include a variable in a select into statement enclosed in srw.do_sql()
srw.do_sql('select count(emp_id)
into ' || v_ct ||
' from table1 t1, table2 t2
where trunc(t1.date_entered) = ''12-MAR-07''
and t1.test = t2.test_link');

the variable v_ct is not being recognised.

 

[nagornyi]

You don't need SRW.DO_SQL to select into. Just type it in directly. The procudyre is used for DDL, like creating a table, etc. So just put

select count(emp_id)
into v_ct
from table1 t1, table2 t2
where trunc(t1.date_entered) = '12-MAR-07'
and t1.test = t2.test_link;

The variable v_ct is to be declared, of cource.

 

[mbl73]

Thank you very much, I tried it and it worked.

 

[mbl73]

hi nagornyi
Thanks again for the assistance with do_sql. I have another question this time with Oracle Reports Developer. Is it possible to create a report based on a varray? And if it is how do you go about building it?