Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: pl/sql problem

Re: pl/sql problem

From: <oracle_at_nettwerk.com>
Date: Wed, 26 Aug 1998 19:48:26 -0700
Message-ID: <35E4C8FA.BB526F0F@nettwerk.com>


Hi there-

I don't know if this helps, but when I want to pass a variable into a cursor, I do the following:

	cursor temp_cur (p_temp in varchar2) is
		select * from temp_table where thing=p_temp;

Then, when I open the cursor, I do the following:

        open temp_cur('temp value');

...jeff Received on Wed Aug 26 1998 - 21:48:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US