I have a free hand DESKI sql report which executes a stored procedure. The code looks like…
BEGIN
MyPackage( :CBO,@Prompt(‘Select Table’,‘A’,Mono,Free));
END;
This works fine in DESKI but when I export it to the repository and try to run it thorugh Infoview I get the error - The XML response form the server could not be parsed. (Error INF).
I thought it might be because free hand sql reports are based on shared connections and the connection would not be available on the server. I tired creating the connection on the server but it still fails with the same error.
Can you run free hand sql reports via InfoView?
You can run free-hand SQL in Infoview, but I don’t think that is your question. Your question seems to run along the lines of Stored Procedure, and in XI R2 it is not directly possible. Please find this forum note that explains SP in more detail to you:
It is possible that the sheer length of the query itself is lending to the problem. In most likelihood you are passing a lot of SQL verbiage, and there is an upper bound of verbiage that can be passed in an ODBC message (I think it is 1,000 characters, but please don’t quote me on that). I’ve had some rough free-hand SQL that in order to get it to work I’ve had to build a view on the database server (and in that view was all of the complicated stuff). The view avoided me having to pass so much SQL verbiage across the ODBC connection and thus ceased the “XML Response from server could not be parsed” errors. I’m not saying that a view will solve all problems, but in some cases it did solve some of mine. An alternative to creating a view in the database server would of course be to build a derived table in the universe…
Thanks,
John
(BOB member since 2006-09-12)
(BOB member since 2008-07-14)
(BOB member since 2008-07-14)
(BOB member since 2007-06-18)