Deleting Data Definition and Template from back end for BI Publisher report

To delete Data definition and template from Back end for a BI Publisher report the following code must be used.

Script for deleting the datadefinition
————————————————>
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW(‘XX’,’XXHR_EUREH_GEOS_ERROR_REPORT’);
END;
——————————————————–
——————————————————–
script for deleting the template
——————————————————>
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW(‘XX’,’XXHR_EUREH_GEOS_ERROR_REPORT’);
END;

Need to commit after running the script

OR

run the following

declare
begin
delete from XDO_TEMPLATES_B where template_code = ‘template code’;
delete from XDO_TEMPLATES_TL where template_code = ‘template code’;
delete from xdo_lobs where lob_code = ‘template code’;
delete from XDO_DS_DEFINITIONS_TL where data_source_code = ‘data definition code’;
delete from XDO_DS_DEFINITIONS_b where data_source_code = ‘data definition code’;
end;

 

 

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s