Q: ora cursor type

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

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