Recent content by PRice2

Is there any benefit to setting the OracleDataSet/OracleQuery Optimize property to True? I reviewed an older project yesterday where this was set to False. The applicable Oracle version is 11g.

The error message is:

I'd like to use PL/SQL Developer format to export all tables' data. However, one of the tables has a SYS.XMLTYPE column that causes the export to fail. Is there a fix in the near-term for the problem? Thanks, PRice

Great!! Not sure which of the .dproj differences caused the error, but it works, thanks.

I'm moving an IntraWeb project from Delphi XE to XE8 with the latest DOA for XE8 dated 5/11/2015 installed. This morning I got the error message: [dcc32 Fatal Error] F2051 Unit OracleVisual was compiled with a different version of FireDAC.Phys.Oracle.DOAHelpFile stopping on the OracleData unit...

Okay, thanks Marco.

I'm building a Delphi interface to let my customers create a mailing list instead of asking me to do it. When I put the sql into a TOracleQuery, though, it can't get past the spool command to create the desired file name. What would you suggest? The sql works fine in PL/SQL Developer.

Okay, thanks, it isn't a DOA problem. It's an Oracle client problem. Our network admin installed the client from 11.2.0.3 onto Windows 7 when he built the installation image. Although the OCI.dll properties read 11.2.0.1, it isn't backwards compatible when reading from an 11.2 database version...

Any luck on identifying the problem? We have the source, but I haven't found anything yet that solves the problem. If it makes a difference, we've been customers the past ten years, serial number 01.94043.

The client and OCI.dll are 11.2.0.1

We have a little glitch in moving from XP to Windows 7. Our practice when a user needs a new password is to give them a password over the phone and immediately expire it. The problem is that using the DOA dialog results in an ORA-01017 error in Windows 7 after the user enters and verifies their...