Databases Reference
In-Depth Information
See Figure 4-15 for where to put this code.
Figure 4-15.
On Load - After Header Process
For now you have to disable the validation of the PL/SQL code, because the function is not available
yet. Next switch to APEX's SQL Workshop and define that function:
create or replace function GenerateProjectXML
return varchar2
is
l chart data xml varchar2(32767);
l task xml varchar2(32767);
l connector xml varchar2(32767);
cursor tasks is
select link
, task type
, name
, id
