DataWrapOCI Error: Unable to Prepare the query

Question

The script works fine in SQL Developer. I wonder why alteryx is not accepting this.

BH_Mapping_OSKAR.txt

mceleavey · Answer

Hi @LloydVillanueva ,

I suspect this is due to the difference in syntax between the source, which may be SQL, and the destination being in Oracle.

M.

LloydVillanueva · Answer

Hi @mceleavey - I'm trying to connect via Oracle oci as my input tool data. The data script is sourcing from SAP Business Objects.

Query_error.05.11.2021.PNG

mceleavey · Answer

Hi @LloydVillanueva ,

Where are you posting this? What is the use case? What is the format of the data source to which you are writing this? What tool are you using?

M.