PlsqlDocumentTablename

Specifies the table in the database to which all documents (images, pdf-files, etc.) will be uploaded e.g. when using an Html form of enctype="multipart/form-data" and an form-input of type file.

Syntax:
PlsqlDocumentTablename [string]
Default:
[none]
Example:
PlsqlDocumentTablename scott.documents
PlsqlDocumentTablename portal.wwdoc_document (for Portal)
PlsqlDocumentTablename webdb.wwv_document (for WebDB)

Tips for PlsqlDocumentTablename

Using both, a BLOB and LONG RAW column, you can then specify with e.g. PlsqlUploadAsLongRaw html which document extensions should be uploaded into the LONG RAW column. All other document extensions will be uploaded into the BLOB column and the value of the CONTENT_TYPE column will be set accordingly.

If you specify the PlsqlUploadAsLongRaw e.g. to html and your documents table does not have a content column, what means, it does not have a LONG RAW column, Html documents will be uploaded into the BLOB column and the content_type column will be set to LONG RAW.

The documents table must be created with one of the the following structures:

CREATE TABLE documents (
  name          VARCHAR2(256) UNIQUE NOT NULL,
  mime_type     VARCHAR2(128),
  doc_size      NUMBER,
  dad_charset   VARCHAR2(128),
  last_updated  DATE,
  content_type  VARCHAR2(128),
  content       LONG RAW,
  blob_content  BLOB );

Using a BLOB column only:

CREATE TABLE documents (
  name          VARCHAR2(256) UNIQUE NOT NULL,
  mime_type     VARCHAR2(128),
  doc_size      NUMBER,
  dad_charset   VARCHAR2(128),
  last_updated  DATE,
  content_type  VARCHAR2(128),
  blob_content  BLOB );

Using a LONG RAW column only:

CREATE TABLE documents (
  name          VARCHAR2(256) UNIQUE NOT NULL,
  mime_type     VARCHAR2(128),
  doc_size      NUMBER,
  dad_charset   VARCHAR2(128),
  last_updated  DATE,
  content_type  VARCHAR2(128),
  content       LONG RAW );

<>

Take also a look at Upload and Download Procedures Example

If your application does not do document uploads/downloads, this parameter may be omitted

In older versions, this parameter was called document_table