Name
string_to_file — writes a varchar to a file
Synopsis
string_to_file ( |
in path varchar , |
| in string varchar , | |
in mode integer ); |
Description
This function requires dba privileges.
string_to_file writes a
varchar value or string session to a
file. The path is relative to the server's working directory. The
mode is an integer value interpreted as a position. A mode of 0
writes the content starting at offset 0. A mode of -1 appends to
the end of the file. The append option is probably the most useful
for producing application level logs, etc.
The string argument can also be a string output object. In this case the content is used as the string.
If the mode is -2, the new content supersedes the old. This is different from 0 in that the file will be truncated if the new content is shorter than the old.
The DirsAllowed and DirsDenied lists in Parameters section of the virtuoso configuration file (virtuoso.ini by default) are used to control disk access. An error 42000/FA024 is signalled if an attempt is made to write to a file in a directory to which disk access is not explicitly allowed.
Parameters
path
varchar relative path.
string
varchar or string session to write to the file.
mode
integer mode.
| 0 - overwrite from start offset 0 |
| -1 - append to end of file |
| -2 - overwrite and truncate. |
Examples
Example24.411.Simple example
Write an entry to an application log
SQL>string_to_file ('logs/applog.txt',
concat (datestring(now()),'\t','Application started.\n'), -1);
Done. -- 4 msec.
SQL> quit;
bash$ cat logs/applog.txt
2001-03-19 15:15:12.000000 Application started.
bash$