Slightly off topic: does Java or Pro*C "prepare" hit Oracle?

From: <Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com>
Date: Thu, 14 Dec 2000 10:42:21 -0500
Message-Id: <10710.124573@fatcity.com>

Hello,

An argument has raisen in the office about prepared statements.

In many languages (e.g. Pro*C, Java, ADO, etc.) in order to use bind variables and allow for SQL sharing the notion of prepared statements was introduced (a very long time ago).

The question is, when I issue a prepare from any of these languages does the underlying library/driver hit the database?

E.g. If I issue connection.PrepareStatement("SELECT * FROM EMP WHERE EMPID = ?"); in Java, is it actually going to hit Oracle with this statement at this time or when I actually execute the query?

If anybody has any thoughts, knows for sure or has some ideas, please do not hesitate to send them over.

Thanks,
Val Gamerman. Received on Thu Dec 14 2000 - 09:42:21 CST