Re: SQL question!

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/04/06
Message-ID: <6gag00$orj$3@news01.btx.dtag.de>#1/1

Hi,

create or replace procedure test(p_first number, p_second varchar2) is

	cursor cs is
		SELECT
			 this, that, the_other
			FROM 
				my_table
			WHERE 
				this = p_first
			AND 
				that =p_second;

Begin
	FOR PROVV_REC IN C1 LOOP
		NULL;; 
	END LOOP;

End test;

Call:

Begin test(2,'TEST'); END;
/

On Fri, 03 Apr 1998 04:04:29 -0600, chris_at_ultramedia.co.uk wrote:

>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

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de

Received on Mon Apr 06 1998 - 00:00:00 CDT