Hi

This is on 10gR2 / 11gR2

We have a simple "hello world" type java proc in the database which we
can access via a pl/sql wrapper - works fine.

Ouside of the database, we downloaded some java code (lets call it jc)
which provides methods for interacting with a specific web service. We
wrote a simple harness in a Java IDE and this works perfectly.

So far so good.

Now we want to be able to run jc from pl/sql.

So I think the logical thing to do is to load the jc code into the
database.

However as soon as we try to run our harness (which we also compiled
into the db and we know executes without any references to jc) we get
errors.

At this point I am aware that it is customary to add details of code
samples and the error messages we received - I do not have these to hand
and in fact that is not really the question....

Because the question is: are there any specific stpes that need to be
taken to enable (any) jc we load into the db to be able to access for
example lower-level stuff like utl_http for example? Are there any
difference between 10g and 11g in this respect (as we will need to make
this work in both versions)?

The schema into which we loaded jc and are working is able to
successfully execute (from within pl/sql) UTL_HTTP and get responses
from remote servers.

Thanks for any pointers.

--
jeremy

On Feb 5, 6:44*am, Jeremy <jeremy0... (AT) gmail (DOT) com> wrote:
Jeremy,

Part of upgrading a database to 11g (11.2.0.2 at this point) is to
create access control lists for the UTL packages, i.e. UTL_SMTP using
the package DBMS_NETWORK_ACL_ADMIN.
http://www.oracle-base.com/articles/...ices_11gR1.php

This would not likely have affected 10g R2, but possibly it was
backported into the 10.2.0.5 patchset?
You might want to list more detailed version info.

hth.

-bdbafh

In article <3497fa16-854d-40b2-becb-
a1cca3cf445b (AT) j11g2000yqh (DOT) googlegroups.com>, bdbafh (AT) gmail (DOT) com says...
Thanks for that - DB in which we are evaluating "jc" is running
11.2.0.1.0 on Windows Server 2003.

We are able to access e.g. utl_smtp and utl_http from within PL/SQL no
problems there.

Question really at this stage is whether there are any explicit access
rights that need to be granted in order for java code to be able to
access these kinds of network functions.


--
jeremy

For java code, even within the database, to call pl/sql packages, it would need to connect to
the database. The account it uses to connect, would need to have execute rights on those
"low-level" (???) packages.

But why would you put java inside the database and then try to call pl/sql functions in stead of
using a java http client??

In article <4d503b1e$0$14263$ba620e4c (AT) news (DOT) skynet.be>, ghp (AT) skynet (DOT) be
says...
Hi other way around - we want to call java from pl/sql - and it seemed
sensible (?) to put the java in the database as well.

So our app is written in pl/sql. There are some features in an SDK
written in java which will enable our pl/sql to interact with certain
services accessed over the internet.

--
jeremy

On Feb 5, 10:25*am, Jeremy <jeremy0... (AT) gmail (DOT) com> wrote:
Jeremy,
Oracle 11g r2 has introduced many new security requirements.
You may need also to "grand" Java classes access to specific internet
resources:
Example:
dbms_java.grant_permission( <Your Schema>,
'SYS:java.net.SocketPermission', '127.0.0.1:9999',
'connect,resolve' );
Change 'SYS:java.net.SocketPermission' to the class name used to
access internet.
Change '127.0.0.1:9999' to the ip or url required.
Look at this explanation:
http://download.oracle.com/docs/cd/E...n.htm#BABFBDGG


hth
Thomas