function CF_INSTANCEFormula return Char is
L_INSTANCE VARCHAR2(20);
begin
select INSTANCE_NAME INTO L_INSTANCE
from V$INSTANCE;
RETURN L_INSTANCE;
EXCEPTION when others then
RETURN NULL;
end;
In bursting control file Subject should be "subject - ${CF_INSTANCE}"
L_INSTANCE VARCHAR2(20);
begin
select INSTANCE_NAME INTO L_INSTANCE
from V$INSTANCE;
RETURN L_INSTANCE;
EXCEPTION when others then
RETURN NULL;
end;
In bursting control file Subject should be "subject - ${CF_INSTANCE}"