Sitefinity Oracle Installation - General Discussions - General Discussions - Progress Community
 General Discussions

Sitefinity Oracle Installation

  • Sitefinity Oracle Installation
  • After installing the Sitefinity application and connecting to an oracle database, the table creation process is adding quotation marks around the table and columns. Is there a way to disable this feature? Internally the quotation marks have to be included in any query.

    Doesn't work - no quotation marks:
    select content_id from SITEFINITY.sf_blg_psts_pblshd_trnslations;

    Error starting at line : 8 in command -
    select content_id from SITEFINITY.sf_blg_psts_pblshd_trnslations
    Error at Command Line : 8 Column : 35
    Error report -
    SQL Error: ORA-00942: table or view does not exist
    00942. 00000 -  "table or view does not exist"

    Works - with quotation marks:
    select "content_id" from SITEFINITY."sf_blg_psts_pblshd_trnslations";