Prepared Statement and Stored Procedure

[francan00]

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?

 

[Arne Vajhøj]

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

 

[Viks]

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

Just to add to Arne's reply, PreparedStatement are pre-compiled SQL
statements and can be run multiple times with different arguments.

A stored procedure is synonymous to funtions/proc in an programming
language. It takes arguments , has a return type and has a specific
buisness logic to perform.

 

[francan00]

Thanks to both of you!