DataWrapOCI Error: Unable to Prepare the query

[LloydVillanueva]

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

[mceleavey]

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.

[LloydVillanueva]

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

[mceleavey]

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.