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 2005 Forums
 Transact-SQL (2005)
 Call procedure

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-05-02 : 15:19:25
Hello,

I have some code which is used in various procedures.
So I moved this code to a new procedures with 3 parameters:

...
@Id UNIQUEIDENTIFIER,
@Words NVARCHAR(MAX),
@Feedback INT OUTPUT
...

Now I am calling this new procedure from my base procedure:
EXECUTE extProc @Id @Words @Feedback

What am I doing wrong?
Can't I call a procedure from another procedure.
Isn't this the way to do this?

Thank You,
Miguel

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-05-02 : 15:22:15
I don't see anything you are doing wrong, but you also aren't posting all of your information so it's hard to tell.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-05-02 : 15:23:41
EXECUTE extProc @Id, @Words, @Feedback OUT


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-05-02 : 15:54:54
It works now.

Thanks,
Miguel
Go to Top of Page
   

- Advertisement -