#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    8
    Rep Power
    0
    Hi all, thanks a bunch for helping me out
    last time. I got a quick question about
    php ora functions.
    say you do:

    ora_plogon
    ora_open
    ora_parse(sql statement #1)
    ora_exec(sql statement #1)

    now the result set from Oracle is in the
    buffer.

    ora_fetch(out of cursor #1)

    Here are my questions:
    1) What type of cursor does php use for the
    ora_exec?

    2) What I'm concerned is whether I can reuse the cursor #1 with another sql statement?
    Say after all the code above, I do:

    ora_parse(sql statement #2)
    ora_exec(sql statement #2)
    ora_fetch(out of cursor #1)

    3) after the above, which result set is in
    the buffer?

    4) even if I can, is it save or good to reuse
    cursors?


    I apologize if my question sounds elementary, and I hope someone could give me
    some advice on this. Thank you.

    -Will

  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    7
    Rep Power
    0
    Don't worry, you can reuse the curseor. In your example the content of the cursor is the result of the last executed statement.

    The cursor is just a variable which gets initialized when you passit on to a nwe run of ora_exec.

    But, of course after / when reusing it the content gets lost. So, first you need to read everything out of the cursor 1st.

    That's an academic question, why didn't you give it a go ?


    ------------------
    Joerg Fritsch

Similar Threads

  1. the Ora project. *needs coders!*
    By paulvinten in forum Project Help Wanted
    Replies: 1
    Last Post: January 20th, 2004, 08:14 PM
  2. the Ora project. *needs coders!*
    By paulvinten in forum C Programming
    Replies: 0
    Last Post: January 20th, 2004, 02:15 PM

IMN logo majestic logo threadwatch logo seochat tools logo