More in this section
Forums / General Discussions / Sitefinity Oracle Installation

Sitefinity Oracle Installation

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
1 posts, 0 answered
  1. Kirk
    Kirk avatar
    0 posts
    Registered:
    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"
    *Cause:   
    *Action:

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

1 posts, 0 answered