Group: comp.lang.java.programmer
From: =?ISO-8859-1?Q?Arne_Vajh=F8j?=
Date: Sunday, February 24, 2008 7:14 PM
Subject: Re: Prepared Statement and Stored Procedure

francan00@yahoo.com wrote:
> For SQL in my web applications I use PreparedStatement object alot in
> my JDBC working with Oracle 9i.
>
> I also heard the term Stored Procedure. What is the difference between
> Stored Procedure and Prepared Statement?

What is the difference between a Ford car and an apple ?

:-)

PreparedStatement is something you use to execute SQL statement.

A stored procedures is something that most database have (in sligthly
incompatible syntax) that allow you to write "SQL scripts" within
the database (actually in Oracle you can write stored procedures
in Java as well but ...).

To execute a store procedure you would use CallableStatement.

Arne