Re: Getting 'PRINT' output from Stored Procedures

[Laurent Marchal <lm...@smausa.com>]

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.
>>
>