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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
