We have a multitiered environment.
Let us suppose , we open session and start transaction inside one routine(R1) , located on tier A.
Then, this routine calls for another routine(R2) , which is located on tier B.
R2 routine must be executed in the same session with routine R1 in order to see changes in data , which were done by routine R1.And it has to be one transaction.
Is it possible to send session pointer or whatever via net from tier A to tier B in order to connect (on B) to the session opened on A? I saw some TOracleSession properties like ExternalSVC and ExternalSRV. Can they help me?
I have Oracle 9.2i for Win
Thanks
Let us suppose , we open session and start transaction inside one routine(R1) , located on tier A.
Then, this routine calls for another routine(R2) , which is located on tier B.
R2 routine must be executed in the same session with routine R1 in order to see changes in data , which were done by routine R1.And it has to be one transaction.
Is it possible to send session pointer or whatever via net from tier A to tier B in order to connect (on B) to the session opened on A? I saw some TOracleSession properties like ExternalSVC and ExternalSRV. Can they help me?
I have Oracle 9.2i for Win
Thanks
