Here is the code:
=================================
CREATE PROCEDURE `test`.`sp_GetNextInv`( IN nChapterID Int, OUT cInvNo
VarChar(15) )
BEGIN
SELECT '0001214' INTO cInvNo;
END
=================================
This one works. So, knowing that, it appears that there was something wrong
with my original procedure, so I set out to debug it, and found that I had
declared cInvNo as a variable in the procedure as well as it being a
parameter. I think this may have been what was causing the problem. I
removed it, and the procedure works fine now.
I'm new to stored procedures in general, and really "green" when it comes to
MySQL stored procedures. I should have tried the "divide and conquire"
technique to find the problem to begin with. Anyway, mystery solved.
I really appreciate your help on this.
8 messages in com.mysql.lists.dotnetRe: More Stored Procedure Issues
