Re: Bind Variable -- Implicit Cursor

Fahd,

You were almost there...

declare
  l_dummy all_objects.object_name%type;
begin
  for i in 1..1000 loop
    select object_name
    into l_dummy
    from all_object
    where object_id = i;
  end loop;
end;
/

Hope this helps...

-Tim


on 12/20/04 1:58 AM, Fahd Mirza at fahd-m@xxxxxxxxxxx wrote:

> Hi listers,
>  I am afraid, I am going to ask a very simple question. I am trying to learn
> the Bind Variables. I know what are they and how they can be used in explicit
> cursor. But I am at loss at how they would he used in implicit cursor. E.g.
> the following PL/SQL block uses the bind variable explicit cursor and it works
> fine.
> declare
>   type rc is ref cursor;
>   l_rc rc;
>   l_dummy all_objects.object_name%type;
> begin
>       for i in 1...1000
>       loop
>           open l_rc for
>           'select object_name from all_object where object_id=:x' using i;
>           fetch l_rc into l_dummy;
>           close l_rc;
>      end loop;
> end;
> /
> 
> 
> I want to use the bind variable ':x' in implicit cursor like this
> 
> declare 
> begin
>    for i in (select object_name from all_object where object_id=:x' using i)
>    loop
>    end loop;
> end;
> /
> but the above code with For Loop cursor is giving errors. I would be extremely
> grateful for guidance.
> 
> regards,
> Fahd
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 

--
http://www.freelists.org/webpage/oracle-l

Other related posts: