Hi,
is there any way of creating a kind of persistent user session to Oracle?
I mean, pconnect/plogon has obviously nothing to do with real sessions: when my script finishes, all not commited changes are lost immediately (while that persistent connection using my username/password still stays open) - why?! Can one switch this auto-rollback off? I guess not.
Unlike most other databases, Oracle is best-suited for making lots of changes/executing lots of statements and commiting them all at the end - and if I understand it right, it's impossible with PHP. And I just don't understand why: If it's possible to reuse an existing connection, why is there still no way to create a real dedicated persistent connection that could be reused by every call of a script using the same username/password? (I'd like to e.g. issue an INSERT in the first call and COMMIT in the second...)
I tried to google for it, but everyone seems to be interested in commiting every single statement as soon as possible - like I said, it's just fine for most other DBs (MySQL, Postgre), but not for Oracle - so I didn't find anything useful.
Sorry for my poor english.