# 22. Virtuoso Functions Guide - VAD_INSTALL

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## VAD_INSTALL

Invoke VAD installation process
varchar DB.DBA.VAD_INSTALL (in package_uri varchar, in source_type integer);
Description

Invoke the install operation from interactive SQL or from the web user interface. This will:

- enter into atomic mode
- Check for version and prerequisite package compatibility
- Run the pre-install SQL script
- Load all SQL code and other resources in the order given by the developer
- Run any post install SQL code
- If DB.DBA.VAD_INSTALL() succeeded the server comes back on-line.

If there was a failure in mid-install, such as running out of disk or some other serious unrecoverable database error, the server exits. The installation can be undone manually by halting the server, deleting the transaction log file and restarting. The server will start from the checkpoint as if the installation was never attempted.

Parameters
package_uri – URI of VAD file
source_type – The second parameter to VAD_INSTALL controls whether the given path to the package is taken as a filesystem path or a DAV path. Value of 1 means the path is interpreted as a DAV path. The default value is 0 which means the VAD package is read from filesystem path.
See Also

vad_check_uninstallability()

vad_check_installability()

vad_fail_check()

vad_pack()

vad_safe_exec()

vad_uninstall()

vad_load_file()

vad_check()