Jump to content

DeepOne

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

DeepOne's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.