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

SQL Server 2000 Forums

SQL Server Development (2000)

Help! !SQL stored Procedure output parameter.

Author

Topic

sherinbranch
Starting Member

7 Posts

Posted - 2006-02-24 : 12:27:48

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:13

You won't get help by any quicker by cross posting..

What language is that, looks like php to me..

Are you using SQL Server or MySQL?

If SQL Server, post the SP code..

sherinbranch
Starting Member

7 Posts

Posted - 2006-02-24 : 21:57:41

I am using PL/SQL I have this in my C code... Oracle 9i
I am new to this

BEGIN EQUIPMENT_UTILITIES.MOVE_EQUIPMENT(EQNUM, MoveTo, ? ); END;"
*the third argument should be an output param not sure how to do this.
*it's in a CString format
Thanks.

quote:
Originally posted by RickD

You won't get help by any quicker by cross posting..

What language is that, looks like php to me..

Are you using SQL Server or MySQL?

If SQL Server, post the SP code..

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-02-24 : 22:21:09

>>I am using PL/SQL

Sorry Sherinbranch, these forums are MS Sql Server forums. Try posting at dbforums.com.

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources