create function / procedure local vs. remote
Posted by:
Matthew
Date: January 28, 2007 01:54PM
Hello,
I have my database on machine A.
Using MySQL Query Browser...
On machine A, I can create a function / procedure locally when logged on as root.
On machine B, I can log onto the DB on machine A (again as root), but I cannot create procedures or functions on machine A.
Here's some typical syntax (where xxx is the schema and yyyyy is the function)...
DELIMITER $$
DROP FUNCTION IF EXISTS `xxx`.`yyyyy` $$
CREATE FUNCTION `xxx`.`yyyyy`(pName VARCHAR(1024)) RETURNS varchar(1024)
BEGIN
return '';
END $$
DELIMITER ;
Anyone know what's going on?
Thanks,
Matthew
Subject
Views
Written By
Posted
create function / procedure local vs. remote
6527
January 28, 2007 01:54PM
3581
January 28, 2007 02:21PM
3627
January 28, 2007 05:49PM
3450
February 23, 2009 09:13AM
3126
February 23, 2009 06:02AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.