]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

 ·  ·  ·  Contact ·  Index · Login · Register

Contents

Remote Training
Support
SaaS Service

1 registered user
 in last 24 hours

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.



Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy