Re: when using a bound cursor, error found...

On Tue, Mar 29, 2005 at 08:49:49PM +0900, ?????? wrote:
> I 'll use a bound cursor with parameters.
> But when I use such a cursor, I found a error.
> I don't know error message.

It's usually a good idea to post the error message.  In most cases
it should say what's wrong, or at least where something's wrong.

> DECLARE
>   p_param1                        VARCHAR;
>   p_param1                        VARCHAR;

You've declared the same variable twice; the second declaration
should be p_param2.

>        OPEN cur_test(p_param2);
> 
>        for rec_test in cur_test loop

I don't think you can iterate over a cursor this way.  Rather than
use an explicit cursor, why not use "FOR rec_test IN SELECT ..."?
FOR loops automatically use cursors so you don't have to open one
yourself.  But if you want to use a cursor then you could do
something like this:
 OPEN cur_test(p_param2);
 LOOP     FETCH cur_test INTO rec_test;     EXIT WHEN NOT FOUND;     -- rest of code END LOOP;
 CLOSE cur_test;

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/