title: How to create SQL function with JDBC?
body: <p>I want to create SQL function  with JDBC</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION TEST."TO_STRING"(
  nt_in in ntt_varchar2, 
  delimiter_in IN VARCHAR2 DEFAULT ',')
  return varchar2 is
  v_idx PLS_INTEGER;
  v_str varchar2(32767);
  v_dlm VARCHAR2(10);
  v_length NUMBER;
  v_max_size NUMBER;
  begin  
  v_dlm := delimiter_in;
  v_idx := nt_in.FIRST;
  
  v_max_size :=2000;
  WHILE v_idx IS NOT NULL LOOP
    IF (nvl(length(v_str),0) + length(v_dlm) + length(nt_in(v_idx))) &gt; v_max_size THEN 
      if  v_str is null then
        v_str := substr(nt_in(v_idx), 0, v_max_size);
      else
        v_str := v_str || v_dlm || substr(nt_in(v_idx), 0, v_max_size - length(v_str) - length(v_dlm));
      end if;
      EXIT;
    END IF;
    IF (v_str is not null and length(v_str) &gt; 0) THEN
      v_str := v_str || v_dlm || nt_in(v_idx);
    ELSE
      v_str := nt_in(v_idx);
    END IF;
    v_idx := nt_in.NEXT(v_idx);
  END LOOP;
  RETURN v_str;
  end to_string
  </code></pre>
  
  <p>, but get ORA-00900:    invalid SQL statement</p>
  
  <p>Is it possible to create SQL function with JDBC?
  I use Oracle Database 11g Release 11.1.0.0.0</p>