I have created a public http link and try to call dbms_java.loadjava procedure (as mentioned below) from remote server but it still not working through proxy.
However i am getting a success message "Call completed.".
call dbms_java.loadjava('-proxy googledrive.com:443/ https://drive.google.com/uc?id=1nmYo8a5It613poK7bPGXnmRhfRVWarAQ&export=download'
I have created oracle function
create or replace function getAppMtd RETURN varchar2
as language java
when i execute that function through select getAppMtd() from dual; It gives error:
ORA-29540: class org/dataguise/demo/App does not exist
29540. 00000 - "class %s does not exist"
*Cause: Java method execution failed to find a class with the indicated name.
*Action: Correct the name or add the missing Java class
However I am able to do the same on database server by calling below plsql procedure.
and after executing select getAppMtd() from dual;
it shows result: "Hello Ask TOM"
Please suggest as i want to load jar from remote server by making http link of it.
Link : https://drive.google.com/uc?id=1nmYo8a5It613poK7bPGXnmRhfRVWarAQ&export=download
February 18, 2020 - 10:49 am UTC
You need to ensure that:
- The network firewalls allow your database to reach Google Drive
- You've added the ACLs in the database to allow it to reach Google Drive
- You've configured the certificates and any other authentication necessary to read the file
This article on Oracle-base can help you configure database access https://oracle-base.com/articles/misc/utl_http-and-ssl