Recent content by staffanmw

Hi again, problem solved .. I removed the product and reinstalled the beta .. and the profileer works fine again. Best regards, Staffan

I'm afraid not. It worked perfectly just before I upgraded to the beta version.

I upgraded to the the beta today .. and now can't I get the Profiler to work any more. First the app gets hanging .. and after some tryes the only thing I get is a message box with the message "Error stopping Profiler: Result = 2". I'm running with/on: - Version 7.1.3.1378 - Windows XP Pro, SP2

Okey, after a quick upgrade .. and some minor code changes .. I have now a working app again!

Hi Thomas, I was not hoping for that kind of answer .. but, thanks anyway! Regards, Staffan

Hi, I'm running a old application (Delphi 5, DOA 3.4.6.1) with Oracle XE (10.2.0.1.0). The error I get when logging into the database is: ORA-01986 - 'OPTIMIZER_GOAL is obsolete'. The closest thing I have found is the property TOracleSession.OptimizerGoal witch is set to 'ogFirstRows'. Can...

Thanks! Then I dont need to search any more. Still it would be nice if you could put this as a user request from me to DOA's feature list. I'd prefere a boolean property to free the object when the thread is finish. Regards, Staffan

Hi, I create a TOracleQuery in my application like this (i.e. in a click event of a button): with TOracleQuery.Create(Application) do try Session := OSession; Threaded := True; SQL.Add('some sql stmt'); OnThreadExecuted := OQThreadExecuted; OnThreadFinished :=...

I guess you would like to do something like this: if OracleSession1.Connected then begin with OracleDataSet1 do begin Session := OracleSession1; Open; First; while not Eof do begin ShowMessage(FieldByName('FIELD').AsString); Next; end; end; end;

Well, it is possible to write the statement in a diffrent way .. that solves the problem: select a.rowid, a.no, a.name from tab1 a where a.no in (select b.no from tab2 b) and a.no in (select c.no from tab3 c) I think it was a bit to easy to submit a question into the forum .. sorry.

Hi, I've got a TOracleDataSet witch I join three tables, ruffly like this: select a.rowid, a.no, a.name from tab1 a, tab2 b, tab3 c where a.no = b.no and a.no = c.no As you see I've got the column name 'no' in all tables .. this is the problem when I define the column 'no' as a...

Well, I see what you meen .. but, if I run a query on v$session from PLSQL Dev I get the following result: select terminal, program from v$session where schema# != 0 TERMINAL PROGRAM --------- ---------------- SNAKE SNAKE PLSQLDev.exe SNAKE PLSQLDev.exe The empty value in the...

How do 'set' my application name to the program column in the v$session view?

Yupp, It works with one of the work arounds. Case closed. Thanks! Staffan

Version 3.4.4! When? Any more news about this version? Best regards, Staffan