bind variables with jdbc

Hi all,

I have an application that is written in servlets that connects to an oracle database 8.1.7 via jdbc. My DBA has just notify me that I am not using bind variables in my code and was wondering what i'll need to change to utilise this.

At the moment i am just opening a connection, making a statement (sql query) and executing it to return a resultset. Would i need to change all my queries to stored procedures so that bind variables are used or is there another way.

thanks all Received on Tue Mar 30 2004 - 17:23:53 CST