Unfortunately I did not find any ways to get PRINTed output from SQL
server with JDBC.
The only way seem to return the text as OUT variable.
Cheers.
Laurent.
Le 31/01/2010 08:53, Andrus Adamchik a écrit :
Unfortunately no idea. SQLServer docs are somewhat cryptic about the
PRINT function (does it actually print something to the console, or
does it return a value to the user?). Maybe something to ask on a
SQLServer forum, formulating it as a JDBC question (how do I get a
value of PRINT function via JDBC)...
Andrus
On Jan 30, 2010, at 12:55 AM, Laurent Marchal wrote:
Hi all,
I'm trying to get the results of the printed text displayed by a
stored procedure in SQL Server using the "PRINT" function. The stored
procedure do not have any OUT parameters... If I use a ProcedureQuery
like this :
ProcedureQuery query = new ProcedureQuery("StoreProc");
QueryResponse result = context.performGenericQuery(query);
the QueryResponse is empty. Is there a way to get the output with
Cayenne (3.0) ?
Thanks.
Laurent Marchal.
