Our legacy application opens 3 Oracle connections upon startup. We are planning to fix this. We would like 1 connection shared by all components. We are BDE at this moment, and sharing BDE TDatabase is possible using the TDatabase.Handle. However, one component is written in Oracle PRO*C. Documentation says that if we were DOA then we could share the PRO*C connection with Delphi by using TOracleSession.ExternalLDA.
But we are not DOA. We have made a feasability study to migrate to ODAC. I would like to know if a PRO*C sqlda connection could be used by the ODAC componnent as in DOA?
Thanks.
Any equivalent to: TOracleSession.ExternalLDA ?
Hello
To share Oracle connection between TOraSessions without creating new connections, you can use the TOraSession.AssignConnect method. If you need to share connection by LDA (login data area), then you can get LDA from the LDA property of the TOraSession. But it is used in the old Orcale versions. Since Oracle 8 connection can be shared by OCISvcCtx (service context handle). You can get OCISvcCtx from the OCISvcCtx property of TOraSession.
To share Oracle connection between TOraSessions without creating new connections, you can use the TOraSession.AssignConnect method. If you need to share connection by LDA (login data area), then you can get LDA from the LDA property of the TOraSession. But it is used in the old Orcale versions. Since Oracle 8 connection can be shared by OCISvcCtx (service context handle). You can get OCISvcCtx from the OCISvcCtx property of TOraSession.