In Oracle DB 11.2.0.4, linux 6.7 single instance
select get_java_property('java.version') from dual;
SQL> show user
USER is "SYS"
SQL> select get_java_property('java.version') from dual;
select get_java_property('java.version') from dual
*
ERROR at line 1:
ORA-00904: "GET_JAVA_PROPERTY": invalid identifier
I can't find anything on this ORA-00904: "GET_JAVA_PROPERTY": invalid identifier, anyone know why this happens?
This works fine
SQL> SELECT dbms_java.get_ojvm_property(PROPSTRING=>'java.version') FROM dual;
DBMS_JAVA.GET_OJVM_PROPERTY(PROPSTRING=>'JAVA.VERSION')
--------------------------------------------------------------------------------
1.6.0_191
SQL>
thanks