Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error creating SQL Command - Database Expert

I am creating a command however when I go to save the SQL I get two errors.

"Failed to retrieve data from database" and "Failed to execute SQL Statement"

I am working on an Oracle database.

Why would these errors be occuring?

Former Member
Former Member replied


if you are using orcale add command

Replace the following part "CI_SA_RS_HIST"."EFFDT"<date(2009,1,1) with

"CI_SA_RS_HIST"."EFFDT"<sysdate or "CI_SA_RS_HIST"."EFFDT"< TO_DATE('01-JAN-2009')



0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question