invantive documentation
Invantive Support ForumsLog In / Sign Up

file_info: Multi-platform OS File Metadata Properties

read only

  • Catalog: FileSystem
  • Label: File Metadata Properties

Can only retrieve data.

Parameters

Name Data Type Required Default Documentation
ignore_errors varchar2 Whether to ignore errors when accessing the file. Defaults to false.
path varchar2 Relative or absolute path to the file.

Table Columns

The columns of the table file_info are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
created datetime Created fetched only when named
created_utc datetime Created (UTC) fetched only when named
directory_name varchar2 Directory Name fetched only when named
exception_code varchar2 Exception Code fetched only when named The message code of the error.
exception_message varchar2 Exception Message fetched only when named The text of the error.
extension varchar2 Extension fetched only when named
is_archive varchar2 Is Archive File fetched only when named
is_compressed varchar2 Is Compressed File fetched only when named
is_content_indexed varchar2 Is Content Indexed File fetched only when named
is_device varchar2 Is Device File fetched only when named
is_directory varchar2 Is Directory fetched only when named
is_encrypted varchar2 Is Encrypted File fetched only when named
is_existing varchar2 Is Existing fetched only when named
is_hidden varchar2 Is Hidden File fetched only when named
is_integrity_stream varchar2 Is Integrity Stream File fetched only when named
is_normal varchar2 Is Normal File fetched only when named
is_offline varchar2 Is Offline File fetched only when named
is_reparse_point varchar2 Is Reparse Point File fetched only when named
is_scrub_data varchar2 Is Scrub Data File fetched only when named
is_sparse varchar2 Is Sparse File fetched only when named
is_system varchar2 Is System File fetched only when named
is_temporary varchar2 Is Temporary File fetched only when named
is_writable varchar2 Is Writable File fetched only when named
last_access datetime Last Access fetched only when named
last_access_utc datetime Last Access (UTC) fetched only when named
last_write datetime {res:itgen_last_write fetched only when named
last_write_utc datetime Last Write (UTC) fetched only when named
length number File Size (bytes) fetched only when named
name varchar2 Name fetched only when named

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: