Help! !SQL stored Procedure output parameter.

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

General SQL Server Forums

New to SQL Server Programming

Help! !SQL stored Procedure output parameter.

Author

Topic

sherinbranch
Starting Member

7 Posts

Posted - 2006-02-24 : 12:24:23

I am calling a procedure with two input parameters and one output parameter (third) in the following format. I'm receiving a database error on the return parameter. *result. What is the correct syntax for an output parameter.

Code:
CSTRING strSQL;
strSQL.Format("BEGIN EQUIPMENT_UTILITIES.MOVE_EQUIPMENT('%s', '%s', '%d'); END;",(LPCSTR)lpEQNum,(LPCSTR)lpMoveTo, result); <-Failing
at '%d' result.

Thanks.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-02-24 : 12:34:50

Cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62331

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources