PL/SQL Name Function

A "name function" is a PL/SQL routine to return a human readable name of an object for any object type. As a convention, a name function consist of the object_type, followed by "__name" (double underscore).

 

Let's look take a typical example (obtaining the name of a project):

 

select im_project__name(:project_id)

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

 

This PL/SQL function just returns the contents of the im_projects.project_name database field.


  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