Clob as param for PL/SQL Java Stored Procedure

Posted by JDS on Stack Overflow See other posts from Stack Overflow or by JDS
Published on 2010-05-07T01:41:22Z Indexed on 2010/05/07 1:48 UTC
Read the original article Hit count: 448

I have a java stored procedure that takes in a clob representing a chunk of javascript and mins it. The structure of the function calling the JSP is as follows:

function MIN_JS(pcl_js in clob) return clob as
  language java name 'JSMin.min(oracle.sql.CLOB) return oracle.sql.CLOB';

In the actual JSP, I have the following:

import oracle.sql.CLOB;

public class JSMin {
...
public static min(CLOB js) {
...
}

The problem I'm having is that whenever I pass a clob to JS_MIN, it is always interpreted as null inside the JSP. I've checked the clob before calling JS_MIN annd it definitely has contents. Any ideas as to what I'm missing? Any help is greatly appreciated.

© Stack Overflow or respective owner

Related posts about plsql

Related posts about java-stored-procedure