DBMS_AQ

[[email protected]]

Hello

I am testing DBMS_AQ and DBMS_AQADM when I send messages by
pl/sql to a windows client. This works, but not in direct mode I get
OCI function is not linked. What can I do to make it work in direct mode
also?

I'm using an Oracle 9.2.0.7 server and ODAC 6.70.0.42.

Additional question async notification seems not to work with this
server version. Would it be possible to accomplish notification by
using dbms_alert or pipe? Will alert or pipe work in direct mode?

Thank you for any help.

Kurt

[Kurt_Jegge]

If I try t OCIinit before connecting in
direct mode I get
Access violation in address 00F...
in modul 'elogger.dll'

Thanks for your help.

Kurt

[Kurt_Jegge]

I also tried dbms_alert.
It only works in non direct mode
Is there anything I can do about it
since I don't want to use sql-net

best regards
Kurt

[Plash]

Direct mode does not support Oracle OBJECT data types. So if the stored procedures you are calling have such parameters, you cannot use them in Direct mode.

Try to use our components TOraQueue, TOraQueueAdmin, and TOraQueueTable. They work in Direct mode. You can use the Listen method of TOraQueue to wait for messages.

TOraAlerter component can be used to receive events from DBMS_ALERT or DBMS_PIPE. This component works in Direct mode.

[Kurt_Jegge]

Thank you for your response

Is it possible that your queue components only work
in non direct mode because our oracle 9i is a 64bit oracle on
a unix system?

best regards
Kurt

[Plash]

I don't think so. Please specify which method you call and what error message you receive.

[Kurt_Jegge]

I will test it first with your latest version 680d12, which I could
install now with the /force switch.

I let you know.

[Kurt_Jegge]

Thank you Plash

I installed the latest version of odac and removed the
usage of oracle objects with the raw type and
now I works in direct mode.

Again thanks a lot.

With best regards

Kurt