Hi all,
I am trying load a .jar file in PDB. ( A third party file. for example OraSFTP)
ALTER SESSION SET container=pdb1;
SQL> exec sys.dbms_java.loadjava('-v -r rdbms/orasftp/SetupFiles/ora-sftp-1.2.jar');
BEGIN sys.dbms_java.loadjava('-v -r rdbms/orasftp/SetupFiles/ora-sftp-1.2.jar');
END;
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
ORA-06512: at "SYS.DBMS_JAVA", line 587
ORA-06512: at line 1
Note:
I could able to load this in root container. And now available at sys.ora_sftp But these are visible or accessible in PDB.