Oracle DBMS_JAVA_TEST
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Undocumented
AUTHID CURRENT_USER
Dependencies
DBMS_JAVA DBMS_PICKLER_LIB JAVAVM_SYS
DBMS_JAVA_MISC INITJVMAUX JVMRJBCINV
Documented No
First Available 12.1.0
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtpckl.plb
Subprograms
FUNCALL    
 
FUNCALL
Undocumented

Overload 1
dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2)
RETURN VARCHAR2;
-- found in initdbj.sql
FUNCTION endsession RETURN VARCHAR2 as
BEGIN
  RETURN dbms_java_test.funcall('-endsession', ' ');
END;
Overload 2 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2)
RETURN VARCHAR2;
TBD
Overload 3 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2
)
RETURN VARCHAR2;
TBD
Overload 4 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2
)
RETURN VARCHAR2;
TBD
Overload 5 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2
)
RETURN VARCHAR2;
TBD
Overload 6 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2
)
RETURN VARCHAR2;
TBD
Overload 7 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2
)
RETURN VARCHAR2;
TBD
Overload 8 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2
)
RETURN VARCHAR2;
TBD
Overload 9 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2
)
RETURN VARCHAR2;
TBD
Overload 10 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2
)
RETURN VARCHAR2;
TBD
Overload 11 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2
)
RETURN VARCHAR2;
TBD
Overload 12 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2)

RETURN VARCHAR2;
TBD
Overload 13 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2,
s12    IN VARCHAR2)

RETURN VARCHAR2;
TBD
Overload 14 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2,
s12    IN VARCHAR2,
s13    IN VARCHAR2)

RETURN VARCHAR2;
TBD
Overload 15 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2,
s12    IN VARCHAR2,
s13    IN VARCHAR2,
s14    IN VARCHAR2)

RETURN VARCHAR2;
TBD
Overload 16 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2,
s12    IN VARCHAR2,
s13    IN VARCHAR2,
s14    IN VARCHAR2,
s15    IN VARCHAR2)

RETURN VARCHAR2;
TBD
Overload 17 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2,
s12    IN VARCHAR2,
s13    IN VARCHAR2,
s14    IN VARCHAR2,
s15    IN VARCHAR2,
s16    IN VARCHAR2)

RETURN VARCHAR2;
TBD
Overload 18 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2,
s12    IN VARCHAR2,
s13    IN VARCHAR2,
s14    IN VARCHAR2,
s15    IN VARCHAR2,
s16    IN VARCHAR2,
s17    IN VARCHAR2)

RETURN VARCHAR2;
TBD
Overload 19 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2,
s12    IN VARCHAR2,
s13    IN VARCHAR2,
s14    IN VARCHAR2,
s15    IN VARCHAR2,
s16    IN VARCHAR2,
s17    IN VARCHAR2,
s18    IN VARCHAR2)

RETURN VARCHAR2;
TBD
Overload 20 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2,
s12    IN VARCHAR2,
s13    IN VARCHAR2,
s14    IN VARCHAR2,
s15    IN VARCHAR2,
s16    IN VARCHAR2,
s17    IN VARCHAR2,
s18    IN VARCHAR2,
s19    IN VARCHAR2)

RETURN VARCHAR2;
TBD
Overload 21 dbms_java_test.funcall(
class  IN VARCHAR2,
method IN VARCHAR2,
s1     IN VARCHAR2,
s2     IN VARCHAR2,
s3     IN VARCHAR2,
s4     IN VARCHAR2,
s5     IN VARCHAR2,
s6     IN VARCHAR2,
s6     IN VARCHAR2,
s7     IN VARCHAR2,
s8     IN VARCHAR2,
s9     IN VARCHAR2,
s10    IN VARCHAR2,
s11    IN VARCHAR2,
s12    IN VARCHAR2,
s13    IN VARCHAR2,
s14    IN VARCHAR2,
s15    IN VARCHAR2,
s16    IN VARCHAR2,
s17    IN VARCHAR2,
s18    IN VARCHAR2,
s19    IN VARCHAR2,
s20    IN VARCHAR2)

RETURN VARCHAR2;
RETURN VARCHAR2;
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_JAVA
DBMS_JAVA_DEV
DBMS_JAVA_DUMP
DBMS_JAVA_MISC
JAVAVM_SYS
What's New In 12cR2
What's New In 18cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved