Mysql procedure, using parameter in where clause

Question

I made this procedure from phpmyadmin, but it don't works, I replaced the last word from record_id to a specified string id and worked, but when I use the parameter not working.

DROP PROCEDURE `prcd_update_record`;
CREATE DEFINER=`root`@`localhost` 
PROCEDURE `prcd_update_record`(
    IN `talep_id` VARCHAR(24), 
    IN `vall` INT(10)
) 
NOT DETERMINISTIC 
MODIFIES SQL DATA SQL 
SECURITY INVOKER 

UPDATE      `talep_malzeme` 
SET         `kalan_miktar` = vall
WHERE       `talep_malzeme`.`id` = talep_id;

The I execute it like this:

SET @p0='33'; SET @p1='57fb7911ea91e9efa'; CALL `prcd_update_record`(@p0, @p1);

What error you are getting? Add the error you are getting

Jibin Balachandran
– Jibin Balachandran

2016-12-15 12:53:24 +00:00
Commented Dec 15, 2016 at 12:53 — Jibin Balachandran
– Jibin Balachandran, Commented Dec 15, 2016 at 12:53

Manoj Sharma · Accepted Answer · 2016-12-15 12:59:06Z

1

DROP PROCEDURE IF EXISTS `prcd_sevk_toplam`;
create procedure prcd_sevk_toplam(talep_id int, vall VARCHAR(255))
BEGIN
    UPDATE  `talep_malzeme` SET `kalan_miktar` = vall WHERE `talep_malzeme`.`id` = talep_id;
END;

Hope this will help you.

answered Dec 15, 2016 at 12:59

Manoj Sharma

1,4552 gold badges13 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bob Grandys · Accepted Answer · 2016-12-15 13:04:38Z

1

Looks like you has wrong parameter order, try

CALL `prcd_sevk_toplam`(@p1, @p0);

answered Dec 15, 2016 at 13:04

Bob Grandys

1723 bronze badges

Comments

Rahul · Accepted Answer · 2016-12-15 13:17:52Z

1

You should provide proper value to your parameter per your parameter definition. Your procedure accepts parameter as below

PROCEDURE `prcd_sevk_toplam`(
    IN `talep_id` VARCHAR(24), 
    IN `vall` INT(10)

And you are setting both of them to varchar. That could be the issue here. You should set them as

SET @p0=33; 
SET @p1='57fb7911ea91e9efa'; 
CALL `prcd_sevk_toplam`(@p1, @p0);

answered Dec 15, 2016 at 13:17

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Collectives™ on Stack Overflow

Mysql procedure, using parameter in where clause

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related