Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2011-03-04
7
Medium Priority
?
545 Views
Last Modified: 2013-12-19
Servlet code to retrieve parameters (CLOB type) passed from PL/SQL stored procedure by UTL_HTP?
0
Comment
Question by:lemongrass_Japan
  • 3
  • 2
7 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35038487
Are you asking how to call the stored procedure, how to handle the lob or both?
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35038511
0
 

Author Comment

by:lemongrass_Japan
ID: 35041744
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?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Accepted Solution

by:
lemongrass_Japan earned 0 total points
ID: 35058825
After setting the content type as 'application/x-www-form-urlencoded' in HTTP Header i am able to post CLOB to servlet successfully.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35059166
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.
0
 
LVL 23

Expert Comment

by:David
ID: 37831720
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
A solution for Fortify Path Manipulation.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
The viewer will learn how to implement Singleton Design Pattern in Java.
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question