wood burning stoves 2.0*
The moose likes JDBC and the fly likes Search Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Search Stored Procedure" Watch "Search Stored Procedure" New topic
Author

Search Stored Procedure

mash john
Greenhorn

Joined: Sep 04, 2005
Posts: 15
Could anybody send me a sample stored procedure for querying data(Search).

Mash
Dave Salter
Ranch Hand

Joined: Jul 20, 2005
Posts: 292

What database engine are you using. Can you be a bit more specific?
mash john
Greenhorn

Joined: Sep 04, 2005
Posts: 15
It's oracle .
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

In which case you already have example stored procedures in the documentation that came with Oracle. Read the "PL/SQL User's Guide and Reference".


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
mash john
Greenhorn

Joined: Sep 04, 2005
Posts: 15
Just send me a sample stored procedure -dynamically passing the search criteria's and fetching the result.

Mash
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Ok. Email (see my profile) me and we'll discuss my consultancy rates.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30050
    
149

Mash,
You can google for a sample to base yours off.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Search Stored Procedure
 
Similar Threads
query for updating
stored procedure inside another stored procedure
Passing array to CallableStatement
How to get a return value from the stored procedure using callable statement
Help with: java.sql.SQLException: ORA-01008: not all variables bound