# 22. Virtuoso Functions Guide - file_dirlist

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
file_delete
file_dirlist
file_mkdir
file_mkpath
file_stat
file_to_string
file_to_string_outpu...
file_unlink
os_chmod
os_chown
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

## file_dirlist

Returns list with content of file system directory
file_dirlist (in path varchar, [in what integer], [out error any]);
Description

This function requires dba privileges.

This returns the list of the contents of a given file system directory.

Parameters
path – string containing valid path to directory in file system
what – flag designating what to return in the list: 0 - directories, 1 - regular files, 2 - symbolic links, 3 - all entries
error – A variable for returning error messages. If supplied, errors are not signalled.
Return Types

an array of strings containing directory entries.

Errors

SQLState | Error Code | Error Text | Description
--- | --- | --- | ---
42000 | FA016 | Access to %s is denied due to access control in ini file |
39000 | FA017 | Path string is too long. |
42000 | FA018 | Access to %s is denied due to access control in ini file |
39000 | FA019 | Path string is too long. |

See Also

file_unlink file_delete file_mkdir file_mkpath file_stat