File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 30309
    
150

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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Search Stored Procedure