Recent content by Adriano

OK ! Forget everything I said before. My question is: What exactly should I do in order to make a multi-tiered application where the application server opens only one Session to Oracle and this session can be shared for all the connected clients.

In fact it should act like BDE, but does not. In BDE I can use a TSession object with the "AutoSessionName" set to true, if I want o open one Oracle connection to each client. But I do not use the TSession, so I open only one Oracle connection that is shared by all the Clients. I suppose it can...

OK, OK ! The problem is: if you have only ptInput parameters you can call FetchParams once and they keep available forever. But, if you have ptInput as well as ptOutput parameters in the same Client Dataset, After you call the Execute method all the ptInput parameters DISAPPEAR, for the next...

I am completely new to DOA so forgive me if my question is too basic ! My puzzle is: Delphi 5.01 to make a front-end and middle-tier of a multi-tiered application, Oracle 8.1.7 (client & server) and DOA Version 3.4.6 for Delphi 5. When using BDE I made a Remote Data Module that is Multi...

I downloaded the Version 3.4.6 for Delphi 5. In fact when I set the ParamType as ptOutput before calling the Execute method, all ptOutput parameters are correctly updated. But the next time I call FetchParams all Params become ptInput again. As my Stored procedure has 38 parameters and 27 of...

Hello, I have just downloaded the DOA version for Delphi 5 and until now I'm very well impressed about de functionalities it implements. For now I have a question: I use MIDAS in Delphi 5 with an Oracle Stored Procedure that has input parameters as well as output parameters. I replaced the...