MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
HOW TO CONVERT ORACLE TO MYSQL
44297
linda hashim
January 03, 2005 10:56PM
Re: HOW TO CONVERT ORACLE TO MYSQL
25878
frank_alw
February 10, 2005 05:20PM
Re: HOW TO CONVERT ORACLE TO MYSQL
12801
Crucifix
August 26, 2005 03:28AM
Re: HOW TO CONVERT ORACLE TO MYSQL
11478
prabhakaran n
March 09, 2006 06:57AM
Re: HOW TO CONVERT ORACLE TO MYSQL
10740
Roland Bouman
March 09, 2006 02:09PM
Re: HOW TO CONVERT ORACLE TO MYSQL
8017
hanju jang
June 20, 2006 06:42PM
How to convert this Oracle PL/SQL Function to MySQL
19786
errolbug
October 10, 2005 04:16AM
Re: How to convert this Oracle PL/SQL Function to MySQL
26169
Roland Bouman
October 14, 2005 06:49AM
Re: How to convert this Oracle PL/SQL Function to MySQL
56261
Nausher Cholavaram
November 30, 2007 01:53PM
Re: How to convert this Oracle PL/SQL Function to MySQL
5799
anupam tripathi
August 06, 2008 03:24AM
Re: HOW TO CONVERT ORACLE TO MYSQL
6522
Max Walton
January 23, 2006 10:37AM
Re: HOW TO CONVERT ORACLE TO MYSQL
5372
Roland Bouman
January 23, 2006 02:26PM
How to convert Oracle bulk collection, table of records into mysql
8713
Sultana Jahan Rini
February 12, 2006 03:42AM
Re: How to convert Oracle bulk collection, table of records into mysql
5813
Roland Bouman
February 12, 2006 04:18AM
Re: How to convert Oracle bulk collection, table of records into mysql
7509
Sultana Jahan Rini
February 12, 2006 04:51AM
Re: How to convert Oracle bulk collection, table of records into mysql
18363
Roland Bouman
February 12, 2006 07:29AM
Error handling
4875
NITESH SINHA
September 30, 2006 01:18AM
Re: HOW TO CONVERT ORACLE DB APP TO MYSQL
5315
ipbasu
February 06, 2007 12:17AM
Re: HOW TO CONVERT ORACLE DB APP TO MYSQL
7197
Roland Bouman
February 06, 2007 06:18AM
Re: HOW TO CONVERT ORACLE TO MYSQL
6154
srikanth goud
June 23, 2006 08:17PM


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.