Have you given the procedure owner enough privs to execute the statement? Capture the ORA number ($dbh->err, or $dbh->errstr) and check Oracle Metalinks. My guess is you need to execute the following before it'll be close to working:

call dbms_java.grant_permission('<schema>','java.net.SocketPermission'
+,'<hostname>','resolve');

call dbms_java.grant_permission('<schema>','java.net.SocketPermission'
+,'<ipaddress>:<listener port, usually 1521>','resolve,connect');

call dbms_java.grant_permission('<schema>','java.util.PropertyPermissi
+on','*','read,write');

commit;
[download]

rdfield