Recent content by Sven

Yes, but assume the following SQl-Statement select id, name from tablename to delete a record DOA makes select * from tablename. If there are a lot of clob or long field, this take on a 64 k line very much time. (and DOA can only compare the fields id and name) Sven

Hi Marco, if i delete a record with TOracleDataSet.Delete the following is done by DOA 1. create savepoint 2. reads ALL data of the record "for Update" 3. Delete record with rowid 4. commit Why does DOA reads all! data in 2. ? In my case it reads all longs and lobs, but this is not needed and...

Arggh, my fault. I entered a wrong DisplayFormat it should be 0.00 not 0,00 (like in germany, but not in delphi) Thx Sven

Hmm, i will try, but i suppose i will have no luck. Sven

Marco, no, i linked it to a twwdbgrid. Result is rounded. No idea why.... This makes absolutly no sense, because older DataSets works correctly, only new one. ?????? Greetings Sven

Hi, i have a very stupid behaviour of a TDataSet and a TOracleDataSet. The following statement select 3.1415926 from dual creates 3 as a result. All my other DataSet and query are running normal. Only if i add new queries i get this.?????? The PLSQL-Developer creates the right output. I...

Not a great think. The listener "hears" at port 1521 or 1526 (or what ever you configure). Just connect to this ports. I made this between Berlin/Frankfurt/Bremen. There is no difference between local net and Internet. So, no Problem (as long the line is stable) But be aware, that a windows...

Jups, it works. I make heavy use of the orpheus library. No problems beetwen doa and orpheus Sven

Hi all, the package wizard is a great tool. To extend the capabilities Is it possible that the constant declaration are also visible in the TCustomPackage. As a property or function ? Now i have to declare these constants in the package and in delphi. Regards S. Heuer

Hey, sounds very good. If you need a beta tester ... Sven

I use a simple TDBRichEdit control to save text in the db using a lob. On a LAN this is not a great problem. But now i have to use a

arrgh. tomatoes on my eyes, I set DBMS_DDL.Name := 'dbms_ddl'; instead of DBMS_DDL.PackageName := 'dbms_ddl'; Sorry for bothering you and thanks again. Sven

Many thanks Johan, i have trouble to get you example running This i added to the code. DBMS_DDL := OraclePackage.Create(NIL); DBMS_DDL.Session := MySession; DBMS_DDL.Name := 'DBMS_DDL'; ?? If i execute CallProcedure i get an error: Identifier 'ALTER_COMPILE' must be...

hi, I added some function, views procs... to a new database. When i compile these with a toraclequery i fetch after some time an "ora-0604: error occured at recursive SQL level 1 ora-0100 maximum open cursors exceeded." My (pseudo)code is like this qry1.SQL := Select all Invalid Objects...

Keep in mind, if two sessions are sending the same alert with no commit, that the latter session will wait on the first until the first session is comitted... Sven