Recent content by camdebuck

How do I use Oracle Monitor?

Yes, I have verified that. There are no database locks.

No, there is no problem inserting using SQL Plus. Only with the current version of DOA does it lock up (older version of DOA works fine on the same database). Any other suggestions?

There is also one additional trigger. If I delete this trigger, then the delphi app works fine. However, if it is in place, then it hangs. As I mentioned earlier, version 3.3.1 of DOA works fine. However, version 3.4.6.4 hangs and never comes back. Here is the trigger: CREATE OR REPLACE...

Before I forget, I'm using Delphi 4, Database is 9.2.x and client is 8.1.7.

The problem that I am about to detail works fine in the 3.3.1 version of DOA. I'm trying to upgrade to the lastest version, but am having this some problem: I've created a very simply debug app. Contains one unit with a TOracleSession, TOraclewwDataSet, TwwDataSource, and a TwwDBGrid. The...

Okay, I've downloaded, uninstalled, reintalled the download and it appears to be working now. What did you change?

Okay, I've downloaded, uninstalled, reintalled the download and it appears to be working now. What did you change?

Delphi 4.

I'm getting the following error message from oracle when trying to insert. This worked fine with an older version of DOAD. I'm using the lastest DOAD version. If I use an older version, all is fine. We are on Oracle 9.2.x.x. The error message is: ORA-01461 : can find a LONG vlaue only for...

I'm getting the following error message from oracle when trying to insert. This worked fine with an older version of DOAD. I'm using the lastest DOAD version. If I use an older version, all is fine. We are on Oracle 9.2.x.x. The error message is: ORA-01461 : can find a LONG vlaue only for...

Unfortunately, it definately is not locked by another user. If you have Oracle 9i database (must be UTF8) create the following table: CREATE TABLE MYTEST (MYTESTID NUMBER(10), MYINFO VARCHAR2(35), MYNUM NUMBER(10)); INSERT INTO MYTEST VALUES (1,'DATA',8); COMMIT; Once you have done this...

We are using ROWID to update records. Everything worked fine under 8i. We upgraded the database to 9i and we now get "record locked by another user" error message. This only happens on NUMBER type columns. Does anyone know of a work around for this?