January 22, 2009 at 11:29 pm
HI,
this is mysql procedure.
I faced problem to execute this.
Plz help me the call procedure i faced error function .
your answer help lot to me.
CREATE DEFINER=`root`@`localhost` PROCEDURE `Portal_GetSingleMessage`( in pStrItemID int)
begin
DECLARE nextMessageID int ;
DECLARE prevMessageID int ;
call Portal_GetNextMessageID (pStrItemID),out nextMessageID ;
call Portal_GetPrevMessageID (pStrItemID ) ,out prevMessageID ;
SELECT
ItemID,
ModuleID,
Title,
CreatedByUser,
CreatedDate,
Body,
DisplayOrder,
NextMessageID = nextMessageID,
PrevMessageID = prevMessageID
FROM Portal_Discussion
WHERE
ItemID = pStrItemID ;
end
Thanks
Dastagiri.D
January 23, 2009 at 12:30 am
You say you're getting an error when calling that? What would the specific error message be?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 23, 2009 at 12:45 am
Gail, is right you should always post the error message in order for us to help.
But I also noticed that this is a MYSQL procedure, not SQL Server. So you might better post it to a MySQL forum.
[font="Verdana"]Markus Bohse[/font]
January 23, 2009 at 12:51 am
"call Portal_GetNextMessageID (pStrItemID),out nextMessageID ;
call Portal_GetPrevMessageID (pStrItemID ) ,out prevMessageID ;"
what is "Portal_GetNextMessageID"? If it is another stored procedure, then use EXECUTE instead of call.
Other as per Gill, give the entire error mesage.
January 23, 2009 at 1:03 am
MarkusB (1/23/2009)
But I also noticed that this is a MYSQL procedure, not SQL Server. So you might better post it to a MySQL forum.
Good catch. I didn't even read the procedure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply