Re: HOW TO CONVERT ORACLE TO MYSQL

[Max Walton]

I am wondering how I might be able to convert this function listed below. I have searched through the internet and have nothing related to my problem thus far. Any help would be appreciated.

FUNCTION processBulletin(in_clob CLOB) RETURN VARCHAR2
AS LANGUAGE JAVA
NAME 'JavaParser.Bufr_Ingest.processBulletin(java.sql.Clob) return java.lang.String';

So far I have the following:

DELIMITER $$

DROP FUNCTION IF EXISTS `test`.`processBulletin` $$
CREATE FUNCTION `test`.`processBulletin` (in_clob TEXT) RETURNS TEXT
LANGUAGE JAVA
BEGIN
RETURN 'ABC';
END $$

DELIMITER ;

But I can't seem to get it to like the Java stuff. The abc is just temporarily there as a placeholder. Basically a blank function. Any ideas?