Bentley Technical Support are currently reviewing this again but I would appreciate any help/advice.
Oracle table has been created called W_WORD_FILE in DOC0118 Document Locations/Media Types and saved without any errors. (Details below):
Name: Central Storage - Word Docs
Media Type: 3
Location Type: Table
Table Name: W_WORD_FILES
When loading a file from DOC0100 and selecting a .doc file from local PC using:
Location: Central Storage - Word Docs (drop down W_WORD_FILES)
Media: Word Document (drop down Word doc).
The following error appears: ORA-00904: W_FILE_INFO: invalid identifier, ORA-06512: at Norfolk.Doc_Locations_Api Line 915.
Initially it was suggested that the problem was having X_ or W_ prefixes in the Highways scheme but having tested with various table names Bentley Technical Support are now reviewing again.
All we are trying to achieve is to load a document into the table.
When you create a new Document type (Location type = TABLE),please, specify/set a column prefix without ‘_’ (underscore) symbol in it for that table.
On creating TABLE type Document, avoid ‘_’(underscore) symbols in table column names creating a new table type.
Answer Verified By: Sarah Willis-Culpitt