471,090 Members | 1,631 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

Execute Extended Stored Procedure in user defined function


I am trying to execute an Extended Stored Procedure in a User Defined Function I wrote. It really is quite simple but I get an error saying
"Only functions and extended stored procedures can be executed from within a function." All I am trying to do is parse an XLM string by calling

EXEC @intErrorCode = dbo.sp_xml_preparedocument @XMLHandler OUTPUT, @String

@string is a string

any help would be greatly appreciated.

Nov 1 '06 #1
0 2232

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Tim Marshall | last post: by
3 posts views Thread by Bilbo | last post: by
10 posts views Thread by John Bailo | last post: by
1 post views Thread by shsandeep | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.