Solved

passing parameter to stored procedure

Posted on 2008-09-30
3
217 Views
Last Modified: 2012-05-05
have a stored procedure that parse a string and sends back an appropriate formatted string.
the stored procedure works - but this stored procedure is called from other stored procedures and i'm having an issue with syntex
set @value = dob.mystoredprocedure @value
gives a syntex error
if i try set @value = exec dob.mystoredprocedure @value
it doesn't like the exec or the last @value
help
0
Comment
Question by:quigleyryan
3 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22606329
are you using an output parameter, or the return param(which has to be an INT)


if output:
declare @value varchar(50)
exec dob.mystoredprocedure @value output

select @value
0
 
LVL 3

Expert Comment

by:R_Janssen
ID: 22606330
use SELECT....
SELECT @Bla = MyStoredProcOrFunctionOrQuery.
 
0
 

Author Closing Comment

by:quigleyryan
ID: 31501589
thanks - that's perfect
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now