Assume, we have a procedure in SA 10.0.1.4225 (remote database is SA11 or SA12):
CREATE PROCEDURE "remote_user"."p_test_remote_xml"(IN @s CHAR(30000)) result(r CHAR(30000)) at 'main_database;;dba;sp_test_remote_xml'
We get an error when we try to pass an argument with more than 254 characters:
The string is too long (parameter 1) SQLCODE=-973, ODBC 3 State="54000"
However, documentation says nothing about such limitation (or at least I can't find anything about that). Besides, the problem is only with the argument and not with return string.
Is it possible in some other way to pass a string with more than 254 characters to remote procedure? Or using web service is the only way?
From the 12.0.1 "What's new" docs:
Therefore I would assume (but I'm not sure!) that in 10.0.1, you have run into an existing limitation...
Yes, you have hit a known limitation with remote procedures that was eventually resolved in 12.0.1. Sadly, the documentation is not clear enough about the restriction.
answered 17 Nov '11, 13:28