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 |
|
sundara_s
Starting Member
2 Posts |
 Posted - 2002-01-28 : 06:57:39
|
| I have 2 stored proc(Sql Server 2000).Proc 1 will call the proc 2.Proc 2 will returns some o/p parameter to proc 1.Proc 2 has around 20 i/p parameters and 3 o/p parameters.Amoung 3 o/p one parameter has declared as VARCHAR(5000).While returning value to proc 1 this o/p parameter does not returns the whole value(Probably String) and it truncate's the string.I am getting only the part of the String value.This o/p parameter value has to be stored to a table.How we can avoid this problem? Thanks,Sundara.S |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-01-28 : 11:39:56
|
| Sounds like the length of a varchar parameter is longer in one stored procedure than the other. Can you post the contents of both stored procedures? |
 |
|
|
sundara_s
Starting Member
2 Posts |
Posted - 2002-01-29 : 01:50:09
|
quote:
Sounds like the length of a varchar parameter is longer in one stored procedure than the other. Can you post the contents of both stored procedures?
No Both of the parameters are declared as varchar(4000) only.Thanks,Sundara.S |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-29 : 01:57:38
|
| why dont you post your code here. that will help us solve your problem.--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God isEdited by - Nazim on 01/29/2002 01:58:41 |
|
|
|
|
|
|
Stored Procedure