Re: [cx-oracle-users] Using Oracle ADVANCED QUEUING / TYPES with cx_Oracle

[Anthony T. <ant...@gm...>]

See inline.

On 5/20/05, Henning von Bargen <H.v...@t-...> wrote:
> Hello list users,
>=20
> first of all: cx_Oracle is great!
>=20
> Now I'm trying to use DBMS_AQ.
> With DBMS_AQ, you can define an "object type"
> for your messages.
> The output from DBMS_AQ.DEQUEUE is then
> your object type togehter with some additional info,
> i.e.
>=20
>=20
> create or replace
> type AQTEST_MESSAGE_T as object
> ( id           number(8) -- wird =FCberlaufen
> , prioritaet   number(2) -- je h=F6her desto wichtiger
> , inhalt       varchar2(256) -- 256 Bytes sollten erstmal reichen
> );
> /
>=20
> grant execute on AQTEST_MESSAGE_T to public;
>=20
> REM Anlegen einer Queuetabelle f=FCr die LRS-Instanzen
> begin
>   dbms_aqadm.create_queue_table
>   ( queue_table =3D> 'QT_AQTEST_LRS'
>   , queue_payload_type =3D> 'AQTEST_MESSAGE_T'
>   , sort_list =3D> null
>   , multiple_consumers =3D> false
>   , auto_commit =3D> false
>   , compatible =3D> '8.1'
>   , comment =3D> 'Reporting Queue Table f=FCr LRS'
>   );
> end;
> /
>=20
> REM Anlegen einer Queue f=FCr die LRS-Instanzen
> begin
>   dbms_aqadm.create_queue
>   ( queue_name =3D> 'Q_AQTEST_LRS'
>   , queue_table =3D> 'QT_AQTEST_LRS'
>   , queue_type =3D> DBMS_AQADM.NORMAL_QUEUE
>   , auto_commit =3D> false
>   , comment =3D> 'Reporting Queue f=FCr LRS'
>   );
> end;
> /
>=20
> Is it possible (or planned) for cx_Oracle to support
> such Oracle Types directly?

Not possible today but planned.

> As a workaround, right now I'm using a wrapper
> stored procedure that returns the individual members
> of my AQTEST_MESSAGE_T in several out parameters.
>=20
> So there's no need for urgent help, I just want to know...
>=20
>=20
> BTW:
> I tried running the tests with cx_Oracle 4.1 and Python 2.4.1
> using a 10g Database, and those tests using datetime failed.
> There's some comment in the documentation about Python 2.4
> and datetime, but perhaps the tests should be adapted, too.

Fixed. Thanks.

> Henning
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_idt12&alloc_id=16344&opclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>