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)


 Tel Europe: +34 609 953 751
 Tel US: +1 415 200 2465