Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unanswered: Cursor reference out of scope

    I am facing 'cursor reference out of scope' when I am assigning cursor value to the local variable, the sql is as follows
    declare
    cursor c1 as select f1,f2 from t1;
    v_f1 number;
    begin
    for i in c1 loop
    v_f1 :=c1.f1;
    ---

    end loop;
    end;

    Your immediate responce is highly appriciated;

    thanks in advance

    --Jaggu

  2. #2
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    4
    Try following code

    declare
    cursor c1 as select f1,f2 from t1;
    v_f1 number;
    begin
    for i in c1 loop
    v_f1 := i.f1;
    end loop;
    end;

  3. #3
    Join Date
    Aug 2003
    Posts
    123
    Thanks a lot, I am trhough.

    --Jaggu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •