MySQL Forums
Forum List  »  Oracle

Re: HOW TO CONVERT ORACLE TO MYSQL
Posted by: Roland Bouman
Date: January 23, 2006 02:26PM

I don't think this is possible - at least not now.

What you are witnessing here is a call to a static java method, masking as a PLSQL function declaration. Oracle has a java virtual machine aboard (JServer) that handles this. No such thing in MYSQL (or any other rdmbs, or can you do this with PostgreSQL? Anyone?)


You can link external C/C++ functions into MySQL, and there are even some people that know how to pull it of in Delphi. (UDF, see http://dev.mysql.com/doc/refman/5.0/en/adding-functions.html)

Maybe you can find a C/C++ library that implements the functionality you need, you might be able to reference that in your UDF to achieve the same result as the java object fulfills in your Oracle example.

Options: ReplyQuote


Subject
Views
Written By
Posted
43830
January 03, 2005 10:56PM
25636
February 10, 2005 05:20PM
12635
August 26, 2005 03:28AM
11284
March 09, 2006 06:57AM
10584
March 09, 2006 02:09PM
7841
June 20, 2006 06:42PM
6295
January 23, 2006 10:37AM
Re: HOW TO CONVERT ORACLE TO MYSQL
5187
January 23, 2006 02:26PM
4679
September 30, 2006 01:18AM
5135
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.