More in this section

Forums / General Discussions / Sitefinity Oracle Installation

Sitefinity Oracle Installation

1 posts, 0 answered
  1. Kirk
    Kirk avatar
    0 posts
    10 Feb 2012
    06 Dec 2016
    Link to this post

    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";

1 posts, 0 answered