DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: goto first record into cursor

  1. #1
    Join Date
    Oct 2001
    Posts
    4
    Hi
    I have a cursor and and fetch data from this until NOTFOUND.
    I like go to first record in cursor for seconeds whit out
    close and open this .
    please help me

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Hi,
    you can't do that in PL/SQL.
    You have to change the design of your code or open the cursor again.

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    I think it is possible to use more than one cursor with the same select statement. Please correct me if I'm wrong.
    If your intention is to use only twice with the same select statement then If I'm right you can use two cursor. Otherwise you might need a routine to explicitly open and close the cursor for iteration if that's what you want.

  4. #4
    Join Date
    Oct 2001
    Posts
    122

    Cool

    You can not fetch the same record twice from the same cursor simultaneously if this is what you are after.

    Simplest way would be to fetch the value once and use twice (or as many time as you want).




Posting Permissions

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


Click Here to Expand Forum to Full Width