SQL question!

Hi,

How do you pass parameters into an stored-SQL query in Oracle8? (In fact, how do you store the query as well!....)

I'm actually trying to speed up a JDBC-applet and believe that it will be quicker if I store the SQl-query on the database(on NT) and, instead of sending it a complete query, just send it some parameters....

e.g. would it be something like the following stored on the database:

SELECT this, that, the_other
FROM my_table
WHERE this = &first_parameter&
AND that = &second_parameter&;

..and how would I call it?

Many TIA

Chris chris @ ultramedia . co . uk

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 03 1998 - 00:00:00 CST