Recent content by Adelson Smania

Hi, Marco! The problem has been solved! It seems there was something to do with the session we were using, shared with other activities in the system. Now, we are using a dedicated session and everything works fine. Thanks for your atention!

Hi, Marco! Each error occours in the following lines: vLobLocator.Read(vBuffer, 32767) - "Invalid handle" vLobLocator.SaveToFile(vPathSaida) - "Stream read error" Thanks.

Hi! I'm using the code bellow to write a LOB to a file. When the file is too big (above 300 Mb), sometimes I receive a "Stream read error" or an "Invalid handle" error. This seems to occour more frequently when my application is being executed on a Windows 2003 Server. vLobLocator :=...

Thanks for the answer, Marco. ThreadSafe is disabled. We'll enable it and test it. As soon as I get the results, I'll post an answer. Best regards!

Hi, Marco. Some information about our ERP application: - multi-session (each user has a session to communicate with Oracle) - multi-tier (client, server, database) - DLL sharing (DOA is in a BPL consumed by serveral EXE files) The problem occours a few times during the day. In major times...

Hi. I have an intermittent problem im my application using DOA both in Delphi 5 and 2007, and Oracle 10.2.0.3. Sometimes, when I call "OracleSession.Connected := False", I receive a "Access violation at address 61CCC2DB in module 'OraClient10.Dll'" error. Below is the call stack of that error...

Marco: Is it possible to do what I want? I mean, make DOA independent of client version installed in the machine, or anything like that? Thanks!

In addition, you can see a discussion in Oracle forums regarding this subject: http://forums.oracle.com/forums/thread.jspa?messageID=2678580 So, to avoid problems, I see the "client / server exact version" as a best practice.

Hi, Marco. We have a history of problems that were solved updating the Oracle client from 9.2.0.1 to 9.2.0.7, for instance. Reading Oracle documentation (Metalink 207303.1 Doc, for instance) we see that not all the client/server combinations are valid. That's why I have this concern.

Hi, everybody. I've face several problems with my customers when they have different Oracle versions in client and server (client 9.2.0.1 with server 10.2.0.3, for instance). My question: is there any way to became DOA independent of the client version installed in the machine?

Is there a way to debug a PL/SQL code in PL/SQL Developer when that code is called by an external application? Thanks in advance.

Thanks, Marco. The SQLs are the same. I'll verify other possibilities.

Hi, Marco. Yes, both are using the same Oracle Home (in case, 10.2.0.3). We've noticed that strange behaviour by monitoring the SQL instructions sent by our application, and executing them in PL/SQL Developer.

Hi! I'm having a strange behaviour in my application: if I execute a query in it, the execution plan used by Oracle is different than the one used with the same SQL in PL/SQL Developer. I've checked the OptimizerGoal parameter in TOracleSession, and is ogUnchanged. Any tips?

Hi, Marco. Our DBA has found the problem. There's a bug in Oracle 9.2.0.4 that causes the wrong datatype problem, but that depends of some Oracle parameters. We hadn't faced that problem in DOA 3.x because we forced OCI7 mode. Thanks for your attention.