Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Tom Kyte

Thanks for the question, Pascal.

Asked: May 08, 2002 - 7:24 am UTC

Last updated: May 08, 2002 - 7:24 am UTC

Version: 8.1.7

Viewed 1000+ times

You Asked

Hi Tom

I wanted to use some Java Classes found in a Java Package :

java.util.regex (Since Version 1.4 JDK)

I was thinking that may be it could have been available in Oracle 9i , but i have checked and it's not there !

Now , my question is , when is Oracle going to make this Package available in the Oracle Database .

And is it possible and allowed to zip and load this package as SYS into Oracle( or will there be Version and Copy Rights issues here )


Thanks in advance


Pascal





and Tom said...

Hi Pascal,

I work for Tom and he asked me to look at your questions. First, I do
not know when JDK 1.4 will be supported in the database. 9i release 2
has support for JDK 1.3.1 but since 1.4 is fairly new, expect a bit of
time before it can be integrated. 1.4 has substantial changes so it
won't get there in 9i release 2.

You can load the regexp code into the database as SYS. However, do you
plan on extracting it from JDK 1.4 or using a third party regular
expression package like the one from the Apache organization? I'd
suggest checking out the following links.

</code> http://jakarta.apache.org/regexp/index.html http://jakarta.apache.org/oro/index.html

There is an example on Tom's web site that uses the code from the second
URL above. It performs Perl 5.003 pattern matching:

http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:2200894550208 <code>


With that said, since they fall under a different package structure than
the Sun or Oracle classes, it should be okay to load them as SYS without
overwriting any core classes. For the same reason, you should be okay
when/if Oracle puts JDK 1.4 support into the database.

As for copyright issues, I believe there is documentation about software
licensing somewhere on the Apache organization web site. I think it's
pretty much free but I'm a programmer not a lawyer. :-)

Mark Piermarini
Oracle Corporation
Reston, VA




Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library