Recent content by David Keith

We just purchased XE4 yesterday. Will our license cover the XE5 version? XE5 is what we need. Also, can the XE4 version be installed in XE5? Thanks

If I remove the NONVISUAL directive, it seems to compile OK. What gives?

Delphi XE DOA 4.1 Since I added some DOA stuff including the global SessionPool, a TOracleSession and a TOracleQuery, all created at runtime, and set the NONVISUAL compiler directive, I can no longer build my project. I keep getting this error: [DCC Error] OracleVisual.pas(75): E2011 Low bound...

In our setup, we have one user accessing the database, so aside from system queries all cursors will be generated from one user having 1 login for each application instance. In looking at the cursors for the biggest offender - one of our common username sessions - all of the queries were system...

Marco - Since '...Cursors for select statements are closed when the last record has been fetched...' does that mean that you are caching all of the data for the query in the TOracleQuery component (dataset/delta)? Could settings such as IsolationLevel , OptimizerGoal, or any others affect...

The Oracle Server is 11g, the version of DOA is 4.11. Thanks.

We have an application that opens a lot of cursors in Oracle. We are getting Alerts from Oracle that we are exceeding MAXOPENCURSORS. I found that Oracle has a parameter called RELEASE_CURSOR and another HOLD_CURSOR. Here's an excerpt...

I'm using D2009, this wouldn't have anything to do with Unicode would it? Here is my latest iteration, the data that gets put into the database is scrambled and on the third table going in I get the following error: ORA-01438: value larger than specified precision allowed for this column Row...

I tried using FDataset.Fields[0].Value, but it wouldn't work with that. Do I have to create a TList descendant? If I use a record, won't I have the same problem? Would it be feasible to load one row at a time? Or would that kill performance or otherwise not work? another problem that I noticed...

Found it. Wrong role, DDL was executing as SYSDBA. Now I'm trying to figure out how to use TOracleDirectPathLoader to get data from a TDataset into Oracle. So far I'm getting lots of interesting errors, like data in table is bad/wrong, data in one column overwrites data in another column...

I have written some code to use a TOracleScript component to execute multiple DDL commands against an Oracle 11g instance. I generate the commands, by reading the catalog info from M$Access and building the DDL for each object. I have event handlers for all of the output events of the...