eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_JAVA dependencies on DBMS_JAVA

Line 1: package body dbms_java as

1: package body dbms_java as
2:
3: PROCEDURE start_btl as language java name
4: 'oracle.aurora.perf.OracleBTL.startBTL()';
5:

Line 19: return dbms_java_definers.compile_class_(sys_context('userenv', 'current_schema'),

15: return boolean';
16:
17: FUNCTION compile_class(classname VARCHAR2) return NUMBER as
18: begin
19: return dbms_java_definers.compile_class_(sys_context('userenv', 'current_schema'),
20: classname);
21: end;
22:
23: FUNCTION compile_method(classname VARCHAR2,

Line 27: return dbms_java_definers.compile_method_(sys_context('userenv', 'current_schema'),

23: FUNCTION compile_method(classname VARCHAR2,
24: methodname VARCHAR2,
25: methodsig VARCHAR2) return NUMBER as
26: begin
27: return dbms_java_definers.compile_method_(sys_context('userenv', 'current_schema'),
28: classname, methodname,
29: methodsig);
30: end;
31:

Line 36: return dbms_java_definers.uncompile_class_(sys_context('userenv', 'current_schema'),

32: FUNCTION uncompile_class(classname VARCHAR2,
33: permanentp NUMBER default 0) return NUMBER as
34: begin
35: -- call-specs can't have default params
36: return dbms_java_definers.uncompile_class_(sys_context('userenv', 'current_schema'),
37: classname, permanentp);
38: end;
39:
40: FUNCTION uncompile_class(schema VARCHAR2,

Line 45: return dbms_java_definers.uncompile_class_(schema, classname, permanentp);

41: classname VARCHAR2,
42: permanentp NUMBER default 0) return NUMBER as
43: begin
44: -- call-specs can't have default params
45: return dbms_java_definers.uncompile_class_(schema, classname, permanentp);
46: end;
47:
48:
49: FUNCTION uncompile_method(classname VARCHAR2,

Line 55: return dbms_java_definers.uncompile_method_(sys_context('userenv', 'current_schema'),

51: methodsig VARCHAR2,
52: permanentp NUMBER default 0) return NUMBER as
53: begin
54: -- call-specs can't have default params
55: return dbms_java_definers.uncompile_method_(sys_context('userenv', 'current_schema'),
56: classname, methodname,
57: methodsig, permanentp);
58: end;
59:

Line 67: return dbms_java_definers.uncompile_method_(schema, classname,

63: methodsig VARCHAR2,
64: permanentp NUMBER default 0) return NUMBER as
65: begin
66: -- call-specs can't have default params
67: return dbms_java_definers.uncompile_method_(schema, classname,
68: methodname, methodsig,
69: permanentp);
70: end;
71:

Line 90: opstr := dbms_java_definers.get_nth_native_compiler_option(opidx);

86: n number;
87: line compiler_option_type;
88: begin
89: opidx := 0;
90: opstr := dbms_java_definers.get_nth_native_compiler_option(opidx);
91: while opstr is not null loop
92: idx := instr(opstr, newline);
93: lastidx := 0;
94: while idx <> 0 loop

Line 103: opstr := dbms_java_definers.get_nth_native_compiler_option(opidx);

99: idx := instr(opstr, newline, idx + length(newline));
100: end loop;
101:
102: opidx := opidx + 1;
103: opstr := dbms_java_definers.get_nth_native_compiler_option(opidx);
104: end loop;
105: end;
106:
107: PROCEDURE set_native_compiler_option(optionName VARCHAR2,

Line 110: dbms_java_definers.set_native_compiler_option_(optionName,

106:
107: PROCEDURE set_native_compiler_option(optionName VARCHAR2,
108: value VARCHAR2) as
109: begin
110: dbms_java_definers.set_native_compiler_option_(optionName,
111: value,
112: sys_context('userenv','current_schemaid'));
113: end;
114:

Line 119: dbms_java_definers.unset_native_compiler_option_(optionName,

115:
116: PROCEDURE unset_native_compiler_option(optionName VARCHAR2,
117: value VARCHAR2) as
118: begin
119: dbms_java_definers.unset_native_compiler_option_(optionName,
120: value,
121: sys_context('userenv','current_schemaid'));
122: end;
123:

Line 127: return dbms_java_definers.decode_native_compiler_option_(optionName, value);

123:
124: FUNCTION decode_native_compiler_option(optionName VARCHAR2,
125: value VARCHAR2) RETURN VARCHAR2 as
126: begin
127: return dbms_java_definers.decode_native_compiler_option_(optionName, value);
128: end;
129:
130:
131: FUNCTION longname (shortname VARCHAR2) RETURN VARCHAR2 as language java name

Line 189: execute immediate 'select sys.dbms_java_misc.runjava(1) from dual';

185: boolean)';
186:
187: -- RUNJAVA interface
188: FUNCTION runjava(cmdline VARCHAR2) RETURN VARCHAR2 as begin
189: execute immediate 'select sys.dbms_java_misc.runjava(1) from dual';
190: return dbms_java_misc.runjava(cmdline);
191: end;
192:
193: FUNCTION runjava_in_current_session(cmdline VARCHAR2) RETURN VARCHAR2 as begin

Line 190: return dbms_java_misc.runjava(cmdline);

186:
187: -- RUNJAVA interface
188: FUNCTION runjava(cmdline VARCHAR2) RETURN VARCHAR2 as begin
189: execute immediate 'select sys.dbms_java_misc.runjava(1) from dual';
190: return dbms_java_misc.runjava(cmdline);
191: end;
192:
193: FUNCTION runjava_in_current_session(cmdline VARCHAR2) RETURN VARCHAR2 as begin
194: execute immediate 'select sys.dbms_java_misc.runjava_in_current_session(1) from dual';

Line 194: execute immediate 'select sys.dbms_java_misc.runjava_in_current_session(1) from dual';

190: return dbms_java_misc.runjava(cmdline);
191: end;
192:
193: FUNCTION runjava_in_current_session(cmdline VARCHAR2) RETURN VARCHAR2 as begin
194: execute immediate 'select sys.dbms_java_misc.runjava_in_current_session(1) from dual';
195: return dbms_java_misc.runjava_in_current_session(cmdline);
196: end;
197:
198: FUNCTION endsession RETURN VARCHAR2 as

Line 195: return dbms_java_misc.runjava_in_current_session(cmdline);

191: end;
192:
193: FUNCTION runjava_in_current_session(cmdline VARCHAR2) RETURN VARCHAR2 as begin
194: execute immediate 'select sys.dbms_java_misc.runjava_in_current_session(1) from dual';
195: return dbms_java_misc.runjava_in_current_session(cmdline);
196: end;
197:
198: FUNCTION endsession RETURN VARCHAR2 as
199: begin

Line 200: return dbms_java_test.funcall('-endsession', ' ');

196: end;
197:
198: FUNCTION endsession RETURN VARCHAR2 as
199: begin
200: return dbms_java_test.funcall('-endsession', ' ');
201: end;
202:
203: FUNCTION endsession_and_related_state RETURN VARCHAR2 as
204: begin

Line 205: return dbms_java_test.funcall('-endsession', ' ', 'x');

201: end;
202:
203: FUNCTION endsession_and_related_state RETURN VARCHAR2 as
204: begin
205: return dbms_java_test.funcall('-endsession', ' ', 'x');
206: end;
207:
208: FUNCTION set_property(name VARCHAR2, value VARCHAR2) RETURN VARCHAR2 as
209: begin

Line 210: return dbms_java_test.funcall('-setprop', ' ', name, value);

206: end;
207:
208: FUNCTION set_property(name VARCHAR2, value VARCHAR2) RETURN VARCHAR2 as
209: begin
210: return dbms_java_test.funcall('-setprop', ' ', name, value);
211: end;
212:
213: FUNCTION get_property(name VARCHAR2) RETURN VARCHAR2 as
214: begin

Line 215: return dbms_java_test.funcall('-getprop', ' ', name);

211: end;
212:
213: FUNCTION get_property(name VARCHAR2) RETURN VARCHAR2 as
214: begin
215: return dbms_java_test.funcall('-getprop', ' ', name);
216: end;
217:
218: FUNCTION remove_property(name VARCHAR2) RETURN VARCHAR2 as
219: begin

Line 220: return dbms_java_test.funcall('-setprop', ' ', name, '', 'x');

216: end;
217:
218: FUNCTION remove_property(name VARCHAR2) RETURN VARCHAR2 as
219: begin
220: return dbms_java_test.funcall('-setprop', ' ', name, '', 'x');
221: end;
222:
223: FUNCTION show_property(name VARCHAR2) RETURN VARCHAR2 as
224: begin

Line 225: return dbms_java_test.funcall('-showprop', ' ', name);

221: end;
222:
223: FUNCTION show_property(name VARCHAR2) RETURN VARCHAR2 as
224: begin
225: return dbms_java_test.funcall('-showprop', ' ', name);
226: end;
227:
228: -- Methods for controlling destination of java output
229: PROCEDURE set_output (buffersize NUMBER) as

Line 281: return dbms_java_test.funcall('-set_output_to_sql', ' ',

277: if maxlen is null then maxlen := 0; end if;
278: if maxlen < 0 or maxlen != floor(maxlen) then
279: return 'MAXIMUM_LINE_SEGMENT_LENGTH must be a non zero integer'; end if;
280:
281: return dbms_java_test.funcall('-set_output_to_sql', ' ',
282: id,
283: replace,
284: stmt,
285: bindings,

Line 296: return dbms_java_test.funcall('-remove_output_to_sql', ' ', id);

292: end;
293:
294: FUNCTION remove_output_to_sql (id VARCHAR2) return VARCHAR2 as
295: begin
296: return dbms_java_test.funcall('-remove_output_to_sql', ' ', id);
297: end;
298:
299: FUNCTION enable_output_to_sql (id VARCHAR2) return VARCHAR2 as
300: begin

Line 301: return dbms_java_test.funcall('-enable_output_to_sql', ' ', id);

297: end;
298:
299: FUNCTION enable_output_to_sql (id VARCHAR2) return VARCHAR2 as
300: begin
301: return dbms_java_test.funcall('-enable_output_to_sql', ' ', id);
302: end;
303:
304: FUNCTION disable_output_to_sql (id VARCHAR2) return VARCHAR2 as
305: begin

Line 306: return dbms_java_test.funcall('-disable_output_to_sql', ' ', id);

302: end;
303:
304: FUNCTION disable_output_to_sql (id VARCHAR2) return VARCHAR2 as
305: begin
306: return dbms_java_test.funcall('-disable_output_to_sql', ' ', id);
307: end;
308:
309: FUNCTION query_output_to_sql (id VARCHAR2) return VARCHAR2 as
310: begin

Line 311: return dbms_java_test.funcall('-query_output_to_sql', ' ', id);

307: end;
308:
309: FUNCTION query_output_to_sql (id VARCHAR2) return VARCHAR2 as
310: begin
311: return dbms_java_test.funcall('-query_output_to_sql', ' ', id);
312: end;
313:
314: FUNCTION set_output_to_java_ (id VARCHAR2,
315: class_name VARCHAR2,

Line 357: return dbms_java_test.funcall('-set_output_to_java', ' ',

353: if maxlen is null then maxlen := 0; end if;
354: if maxlen < 0 or maxlen != floor(maxlen) then
355: return 'MAXIMUM_LINE_SEGMENT_LENGTH must be a non zero integer'; end if;
356:
357: return dbms_java_test.funcall('-set_output_to_java', ' ',
358: id,
359: replace,
360: class_name,
361: class_schema,

Line 415: return dbms_java_test.funcall('-enable_output_to_java', ' ', id);

411: end;
412:
413: FUNCTION enable_output_to_java (id VARCHAR2) return VARCHAR2 as
414: begin
415: return dbms_java_test.funcall('-enable_output_to_java', ' ', id);
416: end;
417:
418: FUNCTION disable_output_to_java (id VARCHAR2) return VARCHAR2 as
419: begin

Line 420: return dbms_java_test.funcall('-disable_output_to_java', ' ', id);

416: end;
417:
418: FUNCTION disable_output_to_java (id VARCHAR2) return VARCHAR2 as
419: begin
420: return dbms_java_test.funcall('-disable_output_to_java', ' ', id);
421: end;
422:
423: FUNCTION remove_output_to_java (id VARCHAR2) return VARCHAR2 as
424: begin

Line 425: return dbms_java_test.funcall('-remove_output_to_java', ' ', id);

421: end;
422:
423: FUNCTION remove_output_to_java (id VARCHAR2) return VARCHAR2 as
424: begin
425: return dbms_java_test.funcall('-remove_output_to_java', ' ', id);
426: end;
427:
428: FUNCTION query_output_to_java (id VARCHAR2) return VARCHAR2 as
429: begin

Line 430: return dbms_java_test.funcall('-query_output_to_java', ' ', id);

426: end;
427:
428: FUNCTION query_output_to_java (id VARCHAR2) return VARCHAR2 as
429: begin
430: return dbms_java_test.funcall('-query_output_to_java', ' ', id);
431: end;
432:
433: FUNCTION set_output_to_file (id VARCHAR2,
434: file_path VARCHAR2,

Line 461: 'call dbms_java.initialize_output_to_file('||

457: from_stdout,
458: from_stderr,
459: 1,
460: 0,
461: 'call dbms_java.initialize_output_to_file('||
462: sys.dbms_assert.enquote_literal(full_id) ||','||
463: sys.dbms_assert.enquote_literal(file_path) ||')',
464: 'call dbms_java.finalize_output_to_file('||
465: sys.dbms_assert.enquote_literal(full_id) ||')',

Line 464: 'call dbms_java.finalize_output_to_file('||

460: 0,
461: 'call dbms_java.initialize_output_to_file('||
462: sys.dbms_assert.enquote_literal(full_id) ||','||
463: sys.dbms_assert.enquote_literal(file_path) ||')',
464: 'call dbms_java.finalize_output_to_file('||
465: sys.dbms_assert.enquote_literal(full_id) ||')',
466: 1);
467: end;
468:

Line 501: dbms_java_test.funcall('-output_to_trc', ' ', 'ENABLE');

497:
498:
499: PROCEDURE enable_output_to_trc as
500: trash varchar2(100) :=
501: dbms_java_test.funcall('-output_to_trc', ' ', 'ENABLE');
502: begin
503: null;
504: end;
505:

Line 508: dbms_java_test.funcall('-output_to_trc', ' ', 'DISABLE');

504: end;
505:
506: PROCEDURE disable_output_to_trc as
507: trash varchar2(100) :=
508: dbms_java_test.funcall('-output_to_trc', ' ', 'DISABLE');
509: begin
510: null;
511: end;
512:

Line 515: return dbms_java_test.funcall('-output_to_trc', ' ', 'QUERY');

511: end;
512:
513: FUNCTION query_output_to_trc return VARCHAR2 as
514: begin
515: return dbms_java_test.funcall('-output_to_trc', ' ', 'QUERY');
516: end;
517:
518:
519: -- import/export interface --

Line 651: msg := dbms_java_test.funcall('-setrtexeccreds', ' ',

647: ospass varchar2)
648: as
649: msg varchar2(100);
650: begin
651: msg := dbms_java_test.funcall('-setrtexeccreds', ' ',
652: dbuser,
653: osuser,
654: ospass);
655: end;

Line 662: msg := dbms_java_test.funcall('-setrtexeccreds', ' ',

658: ospass varchar2)
659: as
660: msg varchar2(100);
661: begin
662: msg := dbms_java_test.funcall('-setrtexeccreds', ' ',
663: osuser,
664: ospass);
665: end;
666:

Line 807: end dbms_java;

803: function get_jdk_version return VARCHAR2 as
804: language java
805: name 'oracle.aurora.vm.CurrentJDK.version() return java.lang.String';
806:
807: end dbms_java;