Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AQ$_JMS_TEXT_MESSAGE

464552Nov 2 2005 — edited Mar 6 2006
Hi,

I'm currently trying to 'migrate' one of our applications to the 10g Express Edition.

Everything went smoothly and was easy enough.

But then I encountered a problem with one of our pl/sql packages that is accessing the aq$_jms_text_message pl/sql type.

The following piece of code is a stripped down version that re-produces the problem.

<----snip--->
declare
msg sys.aq$_jms_text_message;
begin
msg := sys.aq$_jms_text_message.construct;
end;
<---snip--->
generates
ORA-06550: line 4, column 35:
PLS-00302: component 'CONSTRUCT' must be declared
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored

This is also true, if I log on as sys.

I issued the following query to find out what's wrong:

<--- snip --->
select * from all_type_methods where type_name like '%JMS%';
<--- snip --->

and it just returned three lines for AQ$_JMS_HEADER. On the 9.2.0.5 database that we use in production significantly more line were returned and I currently have no access to out 10g development system, but we never had problems on that either.

So my question is: Is this an issue with the 10g Express Edition or is there something else I have to do?

Thanks for any help,
Torsten
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2006
Added on Nov 2 2005
7 comments
627 views