Very Urgent!! Stored Procedure Problem!!!

Hi Friends,

I am in a great trouble!! I hv a procedure which has a print statement in it. Is it possible to capture or redirect the output of my print message?

Say, my procedure is like

create procedure MyProc as

select * from table1

print"Hello World!!"

go

When I run my JDBC query thru CallableStatement my result set holds only the value of select query, but what my "Hello World!!" ?

Thanks.

Kesavan.

[524 byte] By [kes_javaman] at [2007-9-26 5:39:27]