1 Reply Latest reply: Dec 5, 2012 12:41 PM by User405774 RSS

    BI data templates without grouping

    User405774
      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