Hi,
Yeah it print something in the visual SQL managment studio and I'm
pretty sure you can get this output using other programming languages.
I'll try to find answers regarding the JDBC side, and post what I found
here.
Thank you.
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.
