About TOraSession

[Vladimir Petrov]

1. How to set new password without disconnect ?
( I must change password by special stored procedure, and after I try set new password => disconnect. Not so good ).

2. I need connection busy indicator. I have multithread program and I need know "is any statement currently executed in this session ?".

3. I need set many independent procedures for events AfterConnect, BeforeDisconnect, AfterDisconnect. You suggestion ?

[Alex]

1. You can use TOraSession.ChangePassword method to change password or if you must use your own procedure use one more Session to execute it.

2. There is no such functionality in TOraSession but you always can use Before and After events or Executing method (see TOraDataSet.Executing topic in ODAC help) of your DataSets.

3. There are no limitations, you can write them as you wish.

[Vladimir Petrov]

2. ?! I can use other component for SQL statement execution ( not only TDataSet ) or execute it directly with TOraSession.
For example : I have 2 threads and execure long time working SQL.
That happen if I execute SQL statement from other thread at this time ?

[Alex]

Execution of a SQL statement generally consists of on two parts: Execution and Fetching (Fetching part may be absent). The execution flow in NonBlocking mode looks like the following:
1) Executing part of first SQL statement
2) First block fetching of first SQL statement and Executing part of second SQL statement
3) First mixed with second SQL statements fetching.
So delay in execution depends on duration of Execution part.