Solved

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

Posted on 2011-03-04
7
536 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 77

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 77

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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

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 77

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

726 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