Passing Parameter in BI Publisher getting the followoing error: "SQL or ORA exceptions caused due to
Hi guys,
I have an error when passing parameter in query in bi publisher (OBIEE 12.2.1.4.0 (on primise)) and (12.2.4.0.0 (cloud))
the error is " SQL or ORA exceptions caused due to invalid sql, database package state or some database exceptions "
after search, found this doc (Doc ID 2477086.1) and installed patch (Patch 28488603) according to this link :
but after that nothing happened and the error still exists.
*note: - the engine that query on it is (hive).
I will mention two queries and error exists in both of them:
1- first query: