000182231
DateTime values are encapsulated in Single Quotes (') using the Connect for ODBC Oracle Service Cloud driver.
Information |
| Title | DateTime values are encapsulated in Single Quotes (') using the Connect for ODBC Oracle Service Cloud driver. |
|---|
| URL Name | Analytics-Reporting-Download |
|---|
| Article Number | 000182231 |
|---|
| Environment | Product: Connect for ODBC Oracle Cloud Service
Version: 7.10.5.0115 OS: Windows Database: Oracle Service Cloud Application: All supported applications |
|---|
| Question/Problem Description |
|
|---|
| Steps to Reproduce | -Call an Oracle Service Cloud Analytics Report :
CALL REPORTCOLUMNSORT_101065 -Output : "Incident ID", "Subject", "Date Created", "Severity", "Integer3" "1", "Non Native Incident1", "'2008-04-16 12:38:46'", "High", <Null> "2", "Non Native Incident2", "'2008-04-16 13:37:51'", "Medium", <Null> "4", "Unit Test Incident", "'2012-03-19 13:52:21'", "", <Null> "5", "Incident Update All Fields", "'2012-04-26 11:33:55'", "", <Null> "6", "Incident Update Nils", "'2012-04-26 14:17:43'", "", <Null> "7", "Taks Update All", "'2012-05-02 10:08:03'", "", <Null> "8", "Task Update All orig", "'2012-05-02 10:15:04'", "", <Null> "9", "IncidentDestroy", "'2012-05-10 09:54:43'", "", <Null> "10", "GetFileData", "'2012-05-10 10:59:08'", "", <Null> "11", "Incident for 100121-000060", "'2012-05-14 10:02:00'", "", <Null> "12", "Incident for 100127-000042", "'2012-05-14 10:04:16'", "", <Null> "13", "Incident for 100129-000030", "'2012-05-14 10:06:05'", "", <Null> "14", "MTOM Incident Remove", "'2012-05-18 13:36:51'", "", <Null> "15", "MTOM Incident Add", "'2012-05-21 12:39:53'", "", <Null> "16", "........................................ just needed something in here to make CPObject3", "'2012-10-17 08:00:06'", "", <Null> "17", "Target Rule Testing", "'2013-11-18 07:59:45'", "", <Null> "18", "Incident containing All Merge Fields, Standard Text, and Variable Types", "'2013-12-02 12:40:49'", "Medium", <Null> "19", "Test Incident", "'2014-02-05 14:42:00'", "", <Null> "20", "", "'2015-07-13 11:14:16'", "", <Null> "21", "Non Native Incident1", "'2015-07-13 11:26:33'", "High", <Null> 20 rows fetched from 5 columns. |
|---|
| Clarifying Information |
|---|
| Error Message |
|---|
| Defect Number | Defect 31915 |
|---|
| Enhancement Number |
|---|
| Cause |
|
|---|
| Resolution |
|
|---|
| Workaround |
|---|
| Notes |
|---|
| Last Modified Date | 1/22/2016 9:02 AM |
|---|
| Files |
| Disclaimer |
The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information. Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages. |