Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> AQ queues and strings

AQ queues and strings

From: Seth <sgelberg_at_optonline.net>
Date: 18 Apr 2003 06:04:02 -0700
Message-ID: <f3159b28.0304180504.76c3f3ce@posting.google.com>


Can some one send me sample code of how to put a string on and oracle aq queue and conversely how to pull a string from an oracle aq queue.

I know it sounds easy enough, but I can never get it to work - documentation says that there is an implicit conversion between raw/string string/raw for me it always throws an error when I enquue a string onto a raw que.

Seems odd that almost every other queueing system natively supports strings and oracle's doesn't.

I know i could use an object type with one varchar2 attribute, but this defeats the whole purpose I'm trying to get away from using an object type.

Any help would be greatly appreciated. Received on Fri Apr 18 2003 - 08:04:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US