Data Store: Attributes

For Default_Datastore:

This preference uses the DIRECT_DATASTORE object and can be used to create indexes for text columns in which the text is stored directly in the column.

For Detail_Datastore:

binary: Specifies whether Oracle interMedia Text adds the newline character after each row. TRUE for no newline character; FALSE to add newline (\n) character.

detail_key: Name of the foreign key column in the detail table.

detail_lineno: Name of the column in the detail table that orders rows in the table.

detail_table: Name of the detail table in the master-detail relationship.

detail_text: Name of the text column in the detail table.

For Direct_Datastore:

The DIRECT_DATASTORE object is used for text stored directly in the database. It has no attributes.

For File_Datastore:

path: Location of text files that are stored externally in a file system. Multiple paths can be specified for path, with each path separated by a colon (:). File names are stored in the text column in the text table. If path is not used to specify a path for external files, Oracle interMedia Text requires the path to be included in the file names stored in the text column.

Note: If text is stored in external files rather than in a database, the files must be accessible from the host machine on which the Oracle interMedia Text server is running.

For Multi_Column_Datastore (concatenating specified columns in each row to produce a single virtual document; see the product documentation for more information):

columns: The columns to be concatenated to produce a virtual document for each row. Can be any valid syntax for the select-list of a SELECT statement. Example: intro, details, summary

For URL_Datastore:

ftp_proxy: Fully-qualified name of the host machine that serves as the FTP proxy (gateway) for the machine on which Oracle interMedia Text is installed. This attribute must be set if the machine is in an intranet that requires authentication through a proxy server to access Web files located outside the firewall.

http_proxy: Fully-qualified name of the host machine that serves as the HTTP proxy (gateway) for the machine on which Oracle interMedia Text is installed. This attribute must be set if the machine is in an intranet that requires authentication through a proxy server to access Web files located outside the firewall.

maxdocsize: Maximum size, in bytes, that the URL data store supports for accessing HTML documents whose URLs are stored in the database. The valid range for maxdocsize is 1 to 2,147,483,647 (2 gigabytes) and the default is 2,000,000.

maxthreads: Maximum number of threads that can be running at the same time. The valid range for maxthreads is 1 to 1024 and the default is 8.

maxurls: Maximum number of rows that the internal buffer can hold for HTML documents (rows) retrieved from the text table. The valid range for maxurls is 1 to 2,147,483,647 (2 gigabytes) and the default is 256.

no_proxy: String of domains (up to 16, separated by commas) which are found in most, if not all, of the machines in your intranet. When one of the domains is encountered in a host name, no request is sent to the machine(s) specified for ftp_proxy and http_proxy. Instead, the request is processed directly by the host machine identified in the URL. For example, if the string us.oracle.com, uk.oracle.com is entered for no_proxy, any URL requests to machines that contain either of these domains in their host names are not processed by your proxy server(s).

timeout: Length of time, in seconds, that a network operation such as connect or read waits before timing out and returning a timeout error to the application. The valid range for timeout is 0 to 3600 and the default is 30.

Note: Since timeout is at the network operation level, the total timeout time may be longer than the time specified for timeout.

urlsize: Maximum length, in bytes, that the URL data store supports for URLs stored in the database. If a URL is over the maximum length, an error is returned. The valid range for urlsize is 32 to 65535 and the default is 256.

The values specified for maxurls and urlsize, when multiplied, cannot exceed 5000000. In other words, the maximum size of the memory buffer (maxurls * urlsize) for the URL object is approximately 5 megabytes.

For User_Datastore:

output_type: The output type for generated documents: CLOB (default), BLOB, or VARCHAR2.

If the synthesized document is expected to be less than 32000 bytes, then a

VARCHAR2 output function is probably easier to write, easier to test, and

faster to execute than the CLOB version. You can specify BLOB for formatted documents or documents in a different character set. Note, however, than it is still not possible to use or call an external procedure in the user datastore.

procedure: Procedure to be called. The procedure signature requirements are affected by Output_Type. For example, a procedure with CLOB as the output type might have the following signature: PROCEDURE myproc (in rowid, in out CLOB). However, if VARCHAR2 is the output type, the signature must be: PROCEDURE myproc (in rowid, in out VARCHAR2)

Buttons (Apply, Revert, Show SQL/Hide SQL)

See also: Main topics (outline)