I'm using a TOracleEvent to pass an alert on an insert trigger in ORacle 9i 9.2. It is a 2 node RAC cluster. I'm geeting some sporadic results. Sometimes I receive the alert sometimes I don't. Does anyone have any thoughts on why this might be?
I'm using direct Oracle access 4.0.6 with C++ builder 6

Thanks,

Joe

the two transactions I discussed in my previous email are about 6 seconds apart, one successful the other not, do I need to do anything special in my service to queue these transactions if they are comming that quick? Could it be busy handling one transaction and miss another?

You can indeed miss alerts if it takes too long to process them. If you need guaranteed delivery, use AQ instead.

Is that a parameter I can I do that with DOA?

AQ = Advanced Queuing. It is implemented in Oracle through the dbms_aq and dbms_aqadm packages. The Oracle "PL/SQL Packages and Types Reference" describes these packages (and their types) in detail.

Direct Oracle Access 4.0 supports AQ through the TOracleQueue component.

When trying to compile the example showing AQ support I get the following error. Any help? A TOracleObejct require the Direct ORacle Access Obecjt version.

I have the standard version, I just purchased the object version, is there an upgrade available? How can I upgrade my standard edition to object edition? Do I have to uninstall and resinstall or is there an easier method?

Thanks,

Joe

You can simply install the object version. This will replace the standard version.

thanks Marco,

But you didnt really answer all my questions. Is there an upgrade path from the non object version to the object version? Or am I required to purchase a new version?

Thanks,

Joe

Sorry, I missed that. There is indeed a standard-to-object upgrade available. It costs USD 50 per license.