List:General Discussion« Previous MessageNext Message »
From:Nicolas Sebrecht Date:August 7 2008 9:17am
Subject:Strange issue in a stored procedure
View as plain text  

	Hello,

I need help since I fail to set up a basic stored procedure.
Here are the executed commands and the error I get:

mysql> CREATE DATABASE dbtest;
mysql> DELIMITER $$
mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$
mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130))
    -> BEGIN
    -> SET newf = REVERSE( SUBSTRING_INDEX( REVERSE (newf) , '/', 1));
    -> END$$
mysql> DELIMITER ;
mysql> CALL test ('/home/ftp/file.foo');
ERROR 1305 (42000): FUNCTION dbtest.REVERSE does not exist 

I expect to have the string 'file.foo' in newf. 
What's wrong ?

Regards,

-- 
Nicolas Sebrecht

Thread
Strange issue in a stored procedureNicolas Sebrecht7 Aug
  • Re: Strange issue in a stored procedure [SOLVED]Nicolas Sebrecht7 Aug