Creating Data Set in OEM 12c BI Publisher

Hi Friends,

I am trying to create a data model in OEM 12c BI Publisher,

Below is my query.

DECLARE

taskname varchar2(100)

taskdesc varchar2(128)

task_id number

object_id number

timeLimit varchar2(25)

numDaysToRetain varchar2(25)

objectName varchar2(100)

objectType varchar2(100)

BEGIN

taskname := 'SEGMENTADV_4569865'

taskdesc :='Get shrink advice based on object growth trend'

numDaysToRetain :='30'

dbms_advisor.create_task('Segment Advisor',?,taskname,taskdesc,NULL)

dbms_advisor.create_object(taskname, 'TABLESPACE', 'MLMDATA', ' ', ' ', NULL, object_id)

dbms_advisor.set_task_parameter(taskname, 'RECOMMEND_ALL', 'TRUE')

dbms_advisor.set_task_parameter(taskname, 'DAYS_TO_EXPIRE', numDaysToRetain)

END

DECLARE

taskname varchar2(100)