using oracle gateway to access teradata; when I run this query:
WHERE "pcyc" = '1658'
AND "user_id" = '02249521'
AND "Date_Pay" BETWEEN TO_DATE ('05/01/2009', 'mm/dd/yyyy')
AND TO_DATE ('06/30/2009',
i get this error message
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC Teradata Client driver][Teradata]Invalid operation on an ANSI Datetime or Interval value.
ORA-02063: preceding 2 lines from DATAWAREHOUSE
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Note: You must have administrative privileges in order to create/edit Sharing Rules.
Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…