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 |
|
rameshkg
Starting Member
22 Posts |
 Posted - 2004-06-23 : 04:33:47
|
| Hi,I am executing a Stored Procedure through my application. Whenever i try to retrieve the output parameter values in this appln, i am getting an exception. Any idea what is the problem. However thru Query analyser, i am able to display the o/p values.Also, do i need to specifiy the o/p parameters in front of the RETURN statement at the end of the SP ? I have just specified RETURN. However i have just used SELECT 'finished' statement, just before the RETURN statement.Your input is appreciated.RegardsRamesh |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-23 : 04:49:41
|
| You just declare output parameters at the top as output then populate them anywhere in the SP.No idea why the app gives an error buy then you don't give any info.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Unable to retrieve output parameters in SP