12.1. Database Startup


If defined, this is called after the server initialization, including roll forward of transaction logs, compilation of stored procedures, etc..., but before starting to listen for clients. Hence this is guaranteed to run before any clients connect or any HTTP messages are serviced.

The procedure will run in its own transaction, which will be automatically committed upon return, regardless of run time errors. Result sets are not allowed and return values are discarded. All custom Virtuoso Server Extensions (VSEs) will be defined when calling this procedure.

Example 12.1. Sample Startup Procedure Hook

create procedure DB.DBA.DBEV_STARTUP ()
  dbg_obj_print (' server started ');