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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Stored Proc O/P Parameter

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-31 : 00:07:56
Sundar writes "I have 2 stored proc.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.How we can avoid this problem? If anyone give me a solutions for this will help me alot.Thanks"

Nazim
A custom title

1408 Posts

Posted - 2002-01-31 : 00:37:20
Post your Code here. it can give better insight to your problem.




--------------------------------------------------------------
Dont Tell God how big your Problem is , Tell the Problem how Big your God is
Go to Top of Page

Nazim
A custom title

1408 Posts

Posted - 2002-01-31 : 00:37:21
Post your Code here. it can give better insight to your problem.




--------------------------------------------------------------
Dont Tell God how big your Problem is , Tell the Problem how Big your God is
Go to Top of Page
   

- Advertisement -