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
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
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
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
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
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
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,
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
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
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
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,
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,
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
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
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
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,
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:
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:
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 --
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;
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: