ORA Database Error Messages ORA-01787: only one clause allowed per query block June 11, 2015 mpbod ORA-01787: only one clause allowed per query block Cause: An attempt was made to use more than one WHERE, GROUP BY, CONNECT BY, or HAVING clause in the query. Action: Combine the duplicate clauses into a single clause and retry the statement. Back to previous menu https://support.oracle.com/ http://www.oracle.com/ Share this:Click to email a link to a friend (Opens in new window)Click to print (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Pocket (Opens in new window)