Sitefinity Oracle Installation

Posted by Community Admin on 03-Aug-2018 18:45

Sitefinity Oracle Installation

All Replies

Posted by Community Admin on 06-Dec-2016 00:00

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

This thread is closed