Recent content by ddc

  1. D

    ORA-01453: SET TRANSACTION must be first statement

    I never say never. But I do not believe that is occurring. Obviously I cant prove it. I just wanted to make sure that a statement you describe is not in the ToracleSession.Connected call. If it is not, i will dig for the obscure scenario
  2. D

    ORA-01453: SET TRANSACTION must be first statement

    We issue thousands of successful queries and then all of a sudden we get the above error randomly. I have the following scenario. The TOracleSession.IsolationLevel = ilReadCommitted. I also issue a TOracleSession.SetTransaction(tmReadCommitted) for each transaction. I recently added a...
  3. D

    TOracleSession.Connected Hangs

    Marco Any idea or direction you can provide on where in the Connected procedure the app would/might hang (an oracle api function?). If this is an Oracle issue, it would help if I could provide precise information where this is occuring DDC
  4. D

    TOracleSession.Connected Hangs

    when the DB is down, and we try to connect, the following AV occurs Access violation at address 61491B37 in module 'oran9.dll'. Write of address 00000022 most of the time we get ORA-12541: TNS:no listener, or similar errors
  5. D

    TOracleSession.Connected Hangs

    We are running a 24/7 app. The DB goes down daily for 1.5 hours. During that time we catch and handle the errors. On a Oracle 9 client against the 8 DB, we occasionally have a situation where the session.connected := true hangs. no exception thrown. the app is running cause other threads are ok...
Back
Top