I have encountered a weird issue, using Userdefined SQL in Oracle db stage, if the sql size is 11kb then the job fails with the error:
Code: Select all
The provided query statement did not prepare correctly;
So I removed all the whitespace in the query and got it to 9KB and then it works fine. So does that mean we will need to write sql queries not more than the size limit and if so what is the size limit? Is there any way to increase that?