Recent content by Speed

Thanks Marco. Setting Oracle.NoQueryOptimize to True worked a treat. The applications have been rock solid since making that simple change. Thanks very much for your help. Regards, Steve

Ok, thanks Marco. I have set the NoQueryOptimize variable as suggested and so far, so good. Is there a compatibility problem with Oracle 10g and optimized queries? Regards, Steve

Hi Marco, I'm pretty sure it's 00000000 but I'll check with the user to confirm. I don't seem to have Oracle.pas, only Oracle.dcu. If I set Optimize to False for all the TOracleDataset and TOracleQuery components will this do the same thing? Regards, Steve

Some of the applications I maintain have started getting random Access Violations since we migrated the Oracle database over to 10g (from 8i). The AVs only seem to occur when the application is either writing to or reading from the Oracle database. The errors don't happen consistently, but...

The fields are generally either Number or VarChar2, so I'm declaring the variable as an otString and then passing the value using VarToStr. Not sure if this is the right way to do it but it seems to work ok. Regards, Steve

I need to set the value of a field in a table without knowing what type of field it is, but there is no otVariant type for DeclareVariable. How can I set the value of a field using a variant? :confused: Thanks. Regards, Steve

Thanks Marco. It seems to be working fine today so maybe there was some sort of glitch at the Oracle end. Last week it would consistently fail, but today it consistently works, without any changes to the code. Thanks anyway for your help. Regards, Steve

Hi Marco, No I didn't. I'm the only one using the database so would locks be a problem? How do I check for locks? Thanks. Regards, Steve

Never mind. It's been sorted out.

After just upgrading to DOA 4.0.7.1, I'm now getting the following error: ORA-01747: invalid user.table.column, table.column, or column specification. The application has worked fine for years. The only thing that has changed is the upgrade of DOA. Any ideas? Regards, Steve

I'm running the following query in a Delphi 7 application using DOA 4.0.7.1 on an Oracle 10G database: UPDATE BDW.CFG_TBLCONFIG SET LAST_JOB_NO = 0 WHERE KEYFIELD = 1 It works fine if I run it in an SQL window in TOAD, but never finishes when I run it in the application (either at runtime or...

I don't know if this has been asked before but is it possible to pass multiple records to a stored procedure? The Oracle database guys here are writing some stored procedures to pass multiple records to a database and they want to know if I can pass records from a Delphi app (via DOA) to the...

Thanks Phocai. Yeah, I sort of realized this when I looked up the explanation for the error message. It doesn't explain why it has worked fine for years with previous versions of Oracle, eg. 8i. We have 8i running on one server and 10g on another. It works fine under 8i but throws the error...

Thanks for the response Devil. I didn't write this code - I've taken over maintenance of this system. It seems level is being used legitimately, ie. it isn't the name of a column in the table, it's actually referencing the level keyword. The table contains a hierarchical structure.

We are upgrading our Oracle server to 10g. The code below works with previous versions of Oracle, but with 10g it generates the following error: "ORA-01788: CONNECT BY clause required in this query block" Here's the code: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - select...