" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, June 27, 2006 5:15 PM
Subject: Re: Please Help - Stored Procedure Issue
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
@cInvNo
replace all instances of this with just cInvNo. cInvNo is already
declared as
an OUT variable, and @cInvNo wi
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
> @cInvNo
replace all instances of this with just cInvNo. cInvNo is already declared as
an OUT variable, and @cInvNo will be set to that value when you run:
CALL sp_GetNextInv(-1,@cInvNo);
--
Chris White
PHP Programmer/DBBD
Interfuel
--
MySQL Gen
I have the following stored procedure that I'm using:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo VarChar(7))
BEGIN
Declare cPrefix VarChar(1);
Declare cNextInv VarChar(7);
Set cInvNo = '';
IF nChapterID > 0 THEN
Hi All,
Im using MySQL 5.0 and my problem is I am not able to call a
procedure more than once..Its working fine during 1st call..From the
2nd call onwards it vil give some error like
"ERROR 1172 (42000): Result consisted of more than one row "IA
sinilar problem can be found in
"http://bugs.my