Recent content by CraigJ

Thanks for information. It looks like I'll have to spend the money on the professional version.

Thanks for the confirmation. We look forward to the next release.

I think I've found a bug in DOA 3.4.5 using CB 5 and Index Organized tables. It seems that when the table is indexed organized cached updates is basicaly broken. I tried changing the lock mode but just got different errors. The main error I got was "record changed by another user". When I...

I should give some more information: I've installed Kylix OE on RedHat 7.1. I have not yet installed any Oracle software it that matters.

I'm having trouble installing DOA with Kylix OE. Is Open Edition even supported? When I run ./setup.sh I can enter my activation code but when I click on the button I get an wait mouse cursor and the setup just hangs. The directories and files are populated. I tried to run the setup program in...

Thanks for info. It works great.

Given the following SQL in a TOracleQuery: begin sv.UpdateOrderZERT(:ORDERNO, :ITEMNO, :OFFERID, :ZERT); end; All the variables are defined as otInteger except for :ZERT which is defined as otCLOB. I'm trying to use a TLOBLocator and SetComplexVariable to set the value of :ZERT. When I try...

Is it possible for two or more applications (EXEs) to share the same TOracleSession in a DLL? The more I think about this the more I think it would be impossible so difficult that it would not be worth the effort. Any ideas? Craig Jensen craig.jensen@powerquest.com

It works great. Thanks for your help.

Is there a way using DOA to detect the client that's installed? We need to upgrade all our users to Net8 and an easy way to detect the client installed would be helpful. TIA

1) If your ISAPI DLL will use multiple threads then yes set the ThreadSafe property to TRUE. 2) Leave the session connected. 3) If all your threads are using the same session (see #1 above) then there will only be one Oracle session.

Thanks for all the replies. Alex had the best suggestion. Use a SUBSTR around the concatenated columns. I've tested this and it works great. One thing I did find out is that connecting to Oracle 8i DOA computes a much more realistic length for the column. Connecting to Oracle 7 DOA would compute...

I don't realy care about the length returned but DOA does and throws an exception and the application won't run under 8.1.5. I'm wondering why the length is different between Oracle 7 and 8. I also want to know if there is an option in DOA that will let the app run under both Oracle 7 and 8. I...

We are in the process of migrating our database to 8.1.5 from 7.3.4. We have a DOA app that has problems when run against our test 8.1.5 database. Some calculated columns suddenly have the wrong width and an exception occurs. The SQL is usually something like this: SELECT *, 'ID:'| |To_Char(ID)...