February 27, 2014 at 11:06 am
Can you query an Oracle database that is set to "read only" mode?
We have a database in Oracle our Police Department uses that will be placed in read only mode after a new product goes live which uses SQL Server.
We asked if they could still use Crystal Reports to query the database in read only mode until we converted everything over to SSRS, however they (3rd party vendor) stated:
"As long as those reports only require read access (as opposed to execute via stored procedure for example) you should be fine".
I'm not all that familiar with Oracle - I'm all SQL/SSRS and never ran across this issue. I always thought Crystal would create it's own T-SQL and/or exec a view.
Also - if a view needed to create a temporary table to complete the query - would this work with the database being in read only mode?
Sure hope I am making sense! 😉
Thanks in advance!
Britt
City of Odessa, TX | Police Department
March 1, 2014 at 10:38 am
bpriddy (2/27/2014)
Can you query an Oracle database that is set to "read only" mode?We have a database in Oracle our Police Department uses that will be placed in read only mode after a new product goes live which uses SQL Server.
We asked if they could still use Crystal Reports to query the database in read only mode until we converted everything over to SSRS, however they (3rd party vendor) stated:
"As long as those reports only require read access (as opposed to execute via stored procedure for example) you should be fine".
I'm not all that familiar with Oracle - I'm all SQL/SSRS and never ran across this issue. I always thought Crystal would create it's own T-SQL and/or exec a view.
Also - if a view needed to create a temporary table to complete the query - would this work with the database being in read only mode?
Crystal reports can use either straight forward TSQL or reference a stored-procedure. So in the case of a report hitting the oracle database, there shouldn't be an issue. However, creating temporary tables would be out of scope for READONLY and would not be possible (and I don't believe you can even do that in a Crystal Report TSQL query to begin with). SELECTS should work just fine...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 10, 2014 at 8:40 am
Thank you for the response!
I appreciate your feedback regarding a possible issue we may have been facing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply