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.
>
This archive was generated by hypermail 2.0.0 : Sun Jan 31 2010 - 09:54:15 EST