Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Unanswered: Failed to Execute SQL statement

    Hi there, I hope someone can help. I have designed a report in Crystal to run against one of our applications. It works fine at our UK site, but in the US they're getting the 'failed to execute SQL statement. OCI call: ociStmtExecute' error. The application that the report runs against, is the same at both sites (independent instances) and I have made appropriate changes to the report to make it fit the US. Any ideas?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Can you share the SQL statement you are running?
    George
    Home | Blog

  3. #3
    Join Date
    Apr 2009
    Posts
    2

    SQL Statement

    Here's the SQL statement that runs for the report
    Attached Files Attached Files

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    No where clause??

    Try look through your report filters, pay special attention to any date fields that have filters or expressions applied.

    Is it just this report that is affected?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •