Servlet code to retrive parameters (CLOB type) passed from PL/SQL stored procedure by UTL_HTP

Are you asking how to call the stored procedure, how to handle the lob or both?

Here's the link for Oracle's example code working with LOBs:

http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/jdbc20/LOBSample/LOBSample.java.html

If I call the Servlet from stored procedure and pass the CLOB type as parameter to the servlet, it is treated as String in Servlet.... Is it correct approach?

Glad you got it working.

Don't forget to close this out.  I suggest you accept your last post as the solution in case anyone else has this problem.

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.