MySQL Forums
Forum List  »  Oracle

Re: HOW TO CONVERT ORACLE TO MYSQL
Posted by: Max Walton
Date: January 23, 2006 10:37AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
43826
January 03, 2005 10:56PM
25633
February 10, 2005 05:20PM
12631
August 26, 2005 03:28AM
11284
March 09, 2006 06:57AM
10581
March 09, 2006 02:09PM
7839
June 20, 2006 06:42PM
Re: HOW TO CONVERT ORACLE TO MYSQL
6293
January 23, 2006 10:37AM
5187
January 23, 2006 02:26PM
4676
September 30, 2006 01:18AM
5134
February 06, 2007 12:17AM


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.