0 Replies Latest reply: Sep 12, 2012 11:23 AM by 929890 RSS

    Java Stored Procedure returning byte array

    929890
      What would a Java Stored Procedures signature look like taking two String IN parameters and returning a byte[]?
      What limitiations does a byte[] return type have?
      CREATE OR REPLACE FUNCTION "MYSCHEMA"."GETREFERENCEDXMLDOCUMENT"(documentName VARCHAR, containerName VARCHAR) 
      RETURN BLOB AS LANGUAGE JAVA NAME 
      'my.package.MyClass.getReferencedXmlDocument(java.lang.String, java.lang.String) return java.sql.Blob';
      works but if I could use byte[] directly it would have better performance.