Recent content by DaveH

Tried the method you suggest. but the result is the same. Have not tried using DBMS method. If you could help with the syntax, I'd certainly try it. I was unable to easily decipher how to do the deed from online help. Thanks. Dave

CREATE OR REPLACE PROCEDURE WRITE_BLOB (TABLENAME IN VARCHAR2, LOG IN VARCHAR2, TEXTDATA IN VARCHAR2) AS DECLARE SQLSTMT VARCHAR2(200); BEGIN SQLSTMT := 'INSERT INTO ' || TABLENAME || '(LOGNUM, COMENT) VALUES (' || LOG || ','|| TEXTDATA ||')'; EXECUTE IMMEDIATE SQLSTMT...

I have tried every trick offered in every known Oracle forum, to insert text into a BLOB field using dynamic SQL in PLSQL Developer. Having had no success, I am hoping you can help with a code example of how to do that. Surely there must be a way. The important part is the use of Dynamic SQL...

We have been chasing down an intermittent error "Invalid Floating Point Operation" for over a year. Unfortunately it can not be predicted when the error will occur. Using a component named ExceptionMagic, however, we have been able to trace the error to the "ApplyFilterTo" function inside...

But I'm not having any problem with the actual alerts... they are working fine even with the "error"... what I need to know is how to TRAP the error so the user doesn't see it. Is there any way to do this... so far all attempts have failed.

Using 8.1.6.3.1 (8.1.6 with patches) Why would that make a difference?

Using the Alerter Component, I occasionally (but not always) receive the following on program startup: ORA-20000 ORU-10024: There are no alerts registered ORA-06512 SYS.DBMS_ALERT at line 272 ORA-06512 at line 1 Nothing seems to work trying to trap this error. Can you help? FWIW I think...

Not an available option... program is BASED on Runtime Packages, and is HUGE.

Using Runtime Packages... the address is: 0072DB57 in doa34d5.bpl read of address 00000060 Dave

Using DOA 3.4.5, D5 on Windows XP, I can't seem to disconnect the TOraSession without an AV. I have also an Alert Component which frequently requires a long time to "stop". The problem occurs on termination of the application... I explicitly CLOSE all open TOracleDataSets, and when the...

We have been involved with Jackson right from the beginning with the TUsersDOA. Our main application, which relies very heavily on security issues, has been greatly enhanced by using this component set. Programming field level security has always been a very code and time intensive piece of...

We use DevExpress's Quantungrid... they do it with an inmemory table local to the client, so no re-firing of the Query. Works great with result sets up to about 1000 rows. Over that, the grid load time becomes noticeable... BUT the sorting is still immediate if you can absorb the longet grid...

At what point would it be possible to adjust a QBE-generated SQL. Perhaps in "BeforeQBE"? What I want to do is to let QBE do its thing, and then add additional criteria after the SQL is generated. Is this possible? And if so Where? What Event? Dave

I have a very large dataset (over 500,000 rows) of names. If I include an ORDER BY clause in the SQL, the table takes a long time to open. So I don't do that. BUT when I use QBE, I would like the result set to come up "sorted" with an ORDER BY FULLNAME clause. Where would the best place be...

This may be a stupid question, but we are about to launch a project which will need to be cross-platform (using Delphi6 and Kylix) Since there is a DOA for Kylix, does that mean that our code would be cross-platform compatible, or does there need to be a CLX version for D6? I'm not sure of my...