[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

stored procedure

what is stored procedure?tell its usage in Servlets.give examples
0
krsathi
Asked:
krsathi
  • 3
  • 2
1 Solution
 
nietodCommented:
"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
 
IlangoCommented:
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
 
nietodCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
krsathiAuthor Commented:
Answer accepted
0
 
krsathiAuthor Commented:
i need it in detail
0
 
nietodCommented:
>> 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now