Solved

stored procedure

Posted on 2000-05-13
6
230 Views
Last Modified: 2010-04-02
what is stored procedure?tell its usage in Servlets.give examples
0
Comment
Question by:krsathi
  • 3
  • 2
6 Comments
 
LVL 22

Expert Comment

by:nietod
Comment Utility
"Stored procedure" is not a universal term.   What is the context in which you encountered.

"servlets" is not that universal either. At least, I have never heard of it
0
 
LVL 1

Accepted Solution

by:
Ilango earned 20 total points
Comment Utility
When you wanna perform certain database operation efficiently you can do by writing some fucntion/procedures which will get saved as a part of your database system. These are called 'Stored Procedures'. Then you can make use of these procedures from any DB access program. Here is how you can make use of a stored procedure in a servlet.

you may use the Connection object to prepare a  CallableStatement.

    For example:
    Connection.prepareCall("{ ? = call SP(?,?,?) }");
     
     where `? = ` indicates that the stored procedure
           SP is returning a OUT parameter
     
           `?,?...` are optional IN or OUT parameter
     
     If SP does not require any IN or OUT parameter or return value,
     you can simply use "{ call SP }" as the SQL string in  
     prepareCall().
0
 
LVL 22

Expert Comment

by:nietod
Comment Utility
this question has been dead for 3 weeks!  At the very least you should post a comment to see if the client is still interested.  Seeing as he never answered my question, I'm pretty sure he is not interested.  In addition, you are making huge assumptions in your "answer".  
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:krsathi
Comment Utility
Answer accepted
0
 

Author Comment

by:krsathi
Comment Utility
i need it in detail
0
 
LVL 22

Expert Comment

by:nietod
Comment Utility
>> i need it in detail
Then you shouldn't have accepted the answer yet.  Hopefully Ilango, can provide the detail you need, if not you will have to ask a new question as this one is now closed.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

When writing generic code, using template meta-programming techniques, it is sometimes useful to know if a type is convertible to another type. A good example of when this might be is if you are writing diagnostic instrumentation for code to generat…
Article by: SunnyDark
This article's goal is to present you with an easy to use XML wrapper for C++ and also present some interesting techniques that you might use with MS C++. The reason I built this class is to ease the pain of using XML files with C++, since there is…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

762 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now