This discussion is archived
1 Reply Latest reply: Dec 5, 2012 10:41 AM by User405774 RSS

BI data templates without grouping

User405774 Newbie
Currently Being Moderated
Hi,

I created a data template, it has the following query:

SELECT DEPTNO,
DNAME,
LOC,
CURSOR(SELECT EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
nvl(COMM,0) COMM
from EMP ) as EMP
from dept
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?

12.1.3 / 11g

Thanks,
K

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points