PL/SQL Destructor

A "destructor" is a PL/SQL routine  to delete a ]po[ object. As a convention, destructor names consist of the object_type, followed by "__delete" (double underscore), even though there are some older functions not adhering to this convention.

 

Let's look take a typical example (deleting a project):

 

 

select im_project__delete(:project_id)

The only required parameter is the ID of an existing project.

The destructor will delete the project, and all of its super-classes including acs_object and im_biz_object

However, it is possible that the destructor will fail, for example if certain database tables reference the project as part of a referential integrity constraint. In this case please remove the dependency manually (or as part of you deletion script) and try again. The destructor is "atomic", which means that the destructor transaction will be rolled back completely in case of an error.


  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

08902 Hospitalet de Llobregat (Barcelona)

Spain

 Tel Europe: +34 609 953 751
 Tel US: +1 415 200 2465
 Mail: info@project-open.com