ORA stage size limit with userdefined SQL query
Posted: Mon Apr 04, 2011 9:10 am
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:
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?
Code: Select all
The provided query statement did not prepare correctly;