Language: Deutsch · English

Database objects

HOW-TO APPLICATION DEVELOPER UPDATED: JUL 2026 APPLIES TO NUCLOS 4.2026.X

What are database objects?

Database objects configure custom views, functions, procedures etc. as part of a nuclet – they are included in a nuclet transfer. Typical uses: DB functions for calculated attributes, views for virtual business objects, or packages for jobs.

Menu: Configuration → Database → Database objects

Creating an object

First create a database object with a suitable type: function, index, package, package body, procedure, view. A separate object can be stored per supported database system; the one for the active system is used.

Creating a database object and assigning a type.

Entering the source code

In the database object source (Configuration → Database → Database object sources) you enter the DB-specific code. If active is set, the object is created/updated on save. Nuclos prepends the schema/DB name automatically – do not add it yourself. The delete statement runs when the record is deleted.

The „database object source“ screen.

Function body (PostgreSQL)

CREATE OR REPLACE FUNCTION <name>(imoduleid numeric)
  RETURNS numeric AS
$BODY$
  
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;v

Example

CREATE OR REPLACE FUNCTION GET_NEXT_NUMBER(imoduleid numeric)
  RETURNS numeric AS
$BODY$
DECLARE
  iresult NUMERIC (20, 0);
BEGIN
      SELECT intnaechstenummer INTO iresult
      FROM t_eo_nummern
      WHERE strbezeichnung = 'Kundennummer';   
  
   RETURN iresult;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;

Delete statement (PostgreSQL)

DROP FUNCTION IF EXISTS GET_NEXT_NUMBER(imoduleid numeric) CASCADE

Related pages