Recent content by MarkR

Marco, The DOA version is 3.4.5.1 on Delphi 6. When I tried this, I originally had the Oracle Home set to the SQL*NET home. I used the Oracle Home Selector to change it with the project still open in Delphi. Even though the registry settings were changed, DOA did not recognize the change. I...

Hi Marco, I am trying to use a LOBLocator for the first time. When I try to create the LOBLocator, I get the following exception: A TLOBLocator instance requires Net8, which is not detected on this PC. The PC I am trying to run this on has SQL*NET and Net9, but not Net8. Is this a DOA...

Thanks, Marco

Marco, Do you have an update on this issue? Thanks

You should also note that Borland does not certify that executables created with Delphi 5 will work under Win2k. Therefore, I would be somewhat hesitant to write for Win2k with Delphi 5. They do certify executables created with Delphi 6 to run under Win2k.

Without even accessing Oracle, you should be able to track this within your app. Create a boolean variable on your main form called something like UpdatesPending. Initialize it to False. Since a new transaction will start after a commit or rollback, reset the variable to False after a commit...

If all you want is the number of concurrent users, you can setup a stored function which is owned by a user with DBA privileges that returns an Integer value from a select count(*) query on v$session. Then grant execute on that function to all users. You will get the result and none of the...

Marco, When will a version of DOA be available for Oracle 9i and what is the compatibility of the current DOA versions (3.3 and 3.4) with Oracle 9i? Thanks

If you can't use sequences, you can setup a table which has a column of type NUMBER in which you can store the last used or next ID. Run a SELECT ... FOR UPDATE query to retrieve the value (use FOR UPDATE to lock the record), then run an UPDATE query to change the value and commit. Do this as...

I have had some similar performance problems when querying data dictionary views like ALL_TAB_COLUMNS. For example, on our production database, a query to return data on 16 columns for one table takes 2.8 - 3.2 seconds. This occurs whether I use DOA components or query out of SQL*PLUS or any...

That worked great. Thank you very much.

Hi Marco, I need to process a query using an IN expression in the WHERE clause. The code would be something like this: DeclareVariable('agnt', otString); Declare Variable('cty', otString); -- obviously otString in not correct here SQL.Add('SELECT * FROM CLIENT WHERE AGENT_CODE = :agnt AND...

The query is being closed. It is interesting to note that one of the queries in question seems to max out at 60 versions even though the query is closed each time (this query could be run by many different users hundreds of times a day). The app was designed where there would be one...

Marco, When using bind variables with TOracleQuery, how does DOA make the OCI call in reference to the max size of the bind variable? I have noticed that many of our queries used with TOracleQuery have multiple versions in the SGA SQL Area. According to Oracle the issue is that many third...

Thanks, Marco. I guess I just wasn't awake enough to notice that, but neither were the 2 other developers in my office that looked at the code before I posted this item.