Re: Getting 'PRINT' output from Stored Procedures

From: Laurent Marchal (lmarcha..mausa.com)
Date: Thu Feb 04 2010 - 12:13:45 EST

  • Next message: Evgeny Ryabitskiy: "Re: Getting 'PRINT' output from Stored Procedures"

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



    This archive was generated by hypermail 2.0.0 : Thu Feb 04 2010 - 12:14:23 EST