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;