Recent content by Stephan Schmahl

Hi David, it might even be easier. Sure you need a sequence like explained by jpickup. But the trigger is not a must. Just use TOracleDataSet.SequenceField and the work is done for you by ODA!

Indeed I did some more research and the conclusion is that in fact it seems to be an Oracle version problem. After I connect from the 8.17 client to the 8.17 server the exception does not occur any more. I can edit and save the CLOB field. If I connect to the 8.04 server again the exception...

I apologize for the wrong abbreviation. It is in fact an "unexpected datatype" exception, no AV.

Ok that works. But unfortunately I cannot use it because I have to build an installation program and asking for a login as "sys" in order to complete installation would be too insolent. The customer would suppose that a "db spy" or something like that is going to be installed. The same customer...

It's a little bit strange. A long as the CLOB field is empty, connection and read/write is possible and even writing the first input to the CLOB works fine. But on the next table activation the AV occurs. This happens in my EXE and at design time. If I clear the field again with SQLPlus then...

Thanks for your help. It works, but it seems that the user needs to have a dba role in order to execute this query. I wanted to implement a floating license restriction with it (only x concurrent logins are allowed, for the x+1 user the access would be denied). Does there exist a better way to...

After some more research it looks like some kind of version problem. We have two severs. The first is Oracle 8.04 and the second is Oracle 8.17, both on different NT 4.0 server machines. If I try to connect with SQLPlus on the 8.04 server it must be the "xxx.world" format, otherwise the...

Lately I created a new login dialog using unit OracleCI to get a list of database aliases. Though in the tnsnames.ora file an alias called "xxx.world" can be found the OracleAliasList only shows "xxx". Trying to connect ends with an ORA-12154 error. Can anybody help me?

Lately I wanted to build an installation program using TOracleScript for table creation, etc. After installing the meta data I wanted to add quite a lot of insert statements but suddenly the editor didn't accept any more characters. This is a big problem since now I cannot build an universal...

Lately I created an Oracle 8.04 CLOB field and a TOracleDataSet which accessed the corresponding table. I also created a persistent datafield which shows its type as TMemoField and its property BlobType as ftOraClob. On command OracleDataSet1.Open an AV occurred: "Unexpected datatype.". I...

Hi, does anybody know how to get a list of connected users with DOA? It would even be sufficient to know the number of currently active users of the database (tablespace). Any advice would be helpful.

Try method CountQueryHits, which will give you the exact number of records, but will not fetch any record.

I use Oracle 8.0.4, Delphi 5 Enterprise Edition and DOA 3.4.3. In my application I have a small table with two fields of type varchar2(20) both not null with the first field as primary key. The SQL for my TOracleDataSet is "select t.a, t.b, t.rowid from table order by t.a" and I created...