Is there any limit for query size in OCI stage?
Moderators: chulett, rschirm, roy
Is there any limit for query size in OCI stage?
Hello guys,
I am facing some problem related to Oracle stage. In my oracle TARGET stage i am passing a query which i am Selecting and Updating on the same table and that query is too big like it has 1219 characters.
the problem here is if my query is more than 1220 characters its not executing the query and giving fatal that "The provided update statement did not prepare correctly" and update set x.column name = ( se?trim(. and its triming the last part of the query and its not sending the entire query but giving fatal error.
In my job design i am using row generator as source so that i will trigger this query from datastage.
I am facing some problem related to Oracle stage. In my oracle TARGET stage i am passing a query which i am Selecting and Updating on the same table and that query is too big like it has 1219 characters.
the problem here is if my query is more than 1220 characters its not executing the query and giving fatal that "The provided update statement did not prepare correctly" and update set x.column name = ( se?trim(. and its triming the last part of the query and its not sending the entire query but giving fatal error.
In my job design i am using row generator as source so that i will trigger this query from datastage.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you know if this limitation is specific to the Oracle Enterprise stage? It must be as I have a couple of my peoples who loves the long user-defined sqls and I haven't run into this issue on the Server side.
I just pulled one example at random and pasted it into Word for some stats:
Characters: 4893
Characters (with spaces): 15705
I just pulled one example at random and pasted it into Word for some stats:
Characters: 4893
Characters (with spaces): 15705
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I resolved this issue by using ODBC stage. when i executed the same query using Oracle enterprise stage its triming the last characters in the query which are more than 1220 and throwing a fatal error that SQL query not prepared properly, when i used the same after removing some fileds(only to reduce the lenght of query) which is less than 1220 then its working fine.