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.
