Shawn, Madderla,

>Don't you need to DECLARE the variable "mvalidate" before you can use it?

It's declared as OUT mvalidate varchar(10).

PB

-----

SGreen@unimin.com wrote:
madderla sreedhar <sreesind@yahoo.com> wrote on 05/02/2005 03:10:07 AM:

  
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line 
"  := 'TRUE' "

CREATE  PROCEDURE cart_items_validate
(IN mcustid INT ,IN mprodid varchar(10),
OUT mvalidate  varchar(10))

BEGIN

DECLARE rowexists INT(6);


select count(*) into rowexists from esr_cartitems_data

where customer_id=mcustid and item_id=mprodid;

if rowexists>0 THEN
   mvalidate := 'TRUE'
else
   mvalidate := 'FALSE';
end if;

END;


Any help is welcome .



Thanks,

Sreedhar.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

    

Don't you need to DECLARE the variable "mvalidate" before you can use it? 
You already declare rowexists, try adding another declare.


Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine






  

No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.1 - Release Date: 5/2/2005