-
1
- #1
Hi everybody!
We are working with Centura2000 and using Oracle8i as database server. We have encoutered a problem when trying to pass complex sql statements to Oracle. We have some queries that are longer than 1000 characters. When passing these strings to the server, at some point they get truncated and as a result the execution fails. I tried to pass them not as strings but as long strings, unfortunately I've got the same error.
I didn't figure out where the problem could be. Should I modify something on Centura or on Oracle? Is there a parameter in Oracle that needs to be adjusted?
Thanx a lot, I'll appreciate every suggestion.
We are working with Centura2000 and using Oracle8i as database server. We have encoutered a problem when trying to pass complex sql statements to Oracle. We have some queries that are longer than 1000 characters. When passing these strings to the server, at some point they get truncated and as a result the execution fails. I tried to pass them not as strings but as long strings, unfortunately I've got the same error.
I didn't figure out where the problem could be. Should I modify something on Centura or on Oracle? Is there a parameter in Oracle that needs to be adjusted?
Thanx a lot, I'll appreciate every suggestion.