I created a data template, it has the following query:
from EMP ) as EMP
where deptno = nvl(:p_DeptNo,deptno)
When i run the concurrent program, xml output has tags for deptno, dname, loc, but all the values in the cursor are blanks. SQL does return data, but the xml resulting xml tags doesn't have any data. Something must be wrong with the data template that i created.
Can someone pls guide me how to build a data template when inline cursors are used in the SQL?