Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-21 : 10:21:54
|
| Tapan writes "Hi all:I have a J2EE application which accesses SQL Server 2000 database. There are some processing stored proc's which are doing monthly processing. These are called from the Java code.I have implemented a way to pass a small summary and log messages as OUTPUT variables from the procedure to calling program.The log messages variable (call it dSummary)is varchar(7000). Till about 2 days ago this was working fine. In past two days, I have uploaded more data to test this out. After this, the log messages variable is throwing a Null back. The summary (which is varchar(1000) is being passed back properly.Has anyone come across such a problem ? Is there any server level setting that I need to do here?Any help / pointers will take me closer to solution.Thanks in advance.Tapan" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-21 : 10:42:24
|
| I bet you're doing a concat of elements to that variable...If any one of them ISNULL the the whole string will be nullJust wrap ISNULL(@localvar),'') or ISNULL(col,'') around all of you're assignments.That's my guess without seeing any code.Brett8-) |
 |
|
|
|
|
|
OUTPUT variable of varchar type not returning values