-- Allow output from dbms_output.put_line from PL/SQL 
--   and System.out.println() from Java

set serveroutput on
call dbms_java.set_output(2000);

declare 
  query varchar2(32000);
begin
  query := JAvTranslate('+cat +dog rabbit fox -fish');
  dbms_output.put_line ('Query is ' || query);
end;
/
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy