File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle Store  Procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle Store  Procedures" Watch "Oracle Store  Procedures" New topic

Oracle Store Procedures

Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
Using the oracle thin client driver....
1. What is the best way to invoke a stored procedure?
2. Looking for a good book... need to figure out how to write
oracle stored procedures.
TIA Monty

Multi Platform Database Developer & DBA on E.S.T.
Michael Hildner
Ranch Hand

Joined: Oct 13, 2000
Posts: 297
We usually call Oracle stored procedures something like:

Sorry but can't help on a good book as someone else actually writes the procedures that I use. Doesn't look to hard to figure out, though.
Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
thans for your help ...
Multi-Platform Database Developer ( on E.S.T. )
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
All of the Oracle Press books with the grey covers are good.
The is one on PL/SQL which cover what you need
I agree. Here's the link:
subject: Oracle Store Procedures
jQuery in Action, 3rd edition